Date difference

[Guest]

I am trying to use the DateDiff expression, but want the result to display 2
decimal places?

 

[Douglas J. Steele]

DateDiff returns a Long Integer, so displaying decimal places doesn't make
sense.

 

[Guest]

So how can I do the date math and get two decimal places?

 

[storrboy]

You can format the result as a string, or convert it to a Double or
Single, but you'll only get 0's after the decimal.
If you're trying to get a result in days/hours/minutes then perhaps
the following will help guide you.

http://www.mvps.org/access/datetime/date0009.htm

 

[Douglas J. Steele]

What kind of date math?

DateDiff returns the number of "crossings" between two dates: the number of
days represents how many times the date crosses midnight, the number of
weeks represents how many times the date crosses a Sunday, the number of
years represents how many times the date crosses Dec. 31 and so on. You
cannot combine units, therefore, as I said earlier, there are no decimal
places to display.

 

[Guest]

for example: start date: 2/18/1987 end date: 3/7/2007 display result of
20.05

Is there a way to get Excel to do this calculation? I know that Excel can
do this type of calculation.

 

[Douglas J. Steele]

Try using

DateDiff("d", [StartDate], [EndDate]) / 365.25

and either format the result, or use the Round function.