Subtracting START Date from END Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Use DateDiff function.

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

"yyyy" would be years
"m' months
"d" days
"h" hours
"n" minutes
"s" seconds
 
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
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top