Finding the amount of days between two dates.
 

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .

Finding the amount of days between two dates.
 

Maybe

datefrom = #4/1/2008#
dateto = #4/4/2008#
diffference = dateto - datefrom + 1

Mike

"NateBuckley" wrote:

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .

Finding the amount of days between two dates.
 

What does the hash character mean?

And That worked great cheers :)

"Mike H" wrote:

Maybe

datefrom = #4/1/2008#
dateto = #4/4/2008#
diffference = dateto - datefrom + 1

Mike

"NateBuckley" wrote:

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .

Finding the amount of days between two dates.
 

It's part of the syntax for formatting a user date in VB

"NateBuckley" wrote:

What does the hash character mean?

And That worked great cheers :)

"Mike H" wrote:

Maybe

datefrom = #4/1/2008#
dateto = #4/4/2008#
diffference = dateto - datefrom + 1

Mike

"NateBuckley" wrote:

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .