Finding the amount of days between two dates.

[NateBuckley]

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 .

 

[Mike H]

Maybe

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

Mike

 

[NateBuckley]

What does the hash character mean?

And That worked great cheers

 

[Mike H]

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