Subtracting START Date from END Date

[Guest]

I'm using the between [start] and [end] function and wondering if there is a
way to subtract start date from end date to get number of days elapsed. Seems
simple, but I can't get it to work.
Thanks

 

[Guest]

Use DateDiff function.

DateDiff ("d",[end], [start])

"yyyy" would be years
"m' months
"d" days
"h" hours
"n" minutes
"s" seconds

 

[John Vinson]

I'm using the between [start] and [end] function and wondering if there is a
way to subtract start date from end date to get number of days elapsed. Seems
simple, but I can't get it to work.
Thanks

DateDiff("d", [start], [end])

John W. Vinson[MVP]