Calculate days elapsed in Access?

[Guest]

Hello,

Is there a way in access to have it automatically calculate how many days
have passed between a start date and an end date? And if there is no end date
yet, how many day have gone by between the start date and today?

 

[Brendan Reynolds]

Yes, the DateDiff function will do what you want. Details are in the help
file.

 

[Guest]

Hi Niniel

Between 2 dates

=DateDiff("d", [Date1], [Date2])

Between a Date and today

=DateDiff("d", [OrderDate], Date())

Hope this helps

 

[Guest]

=iif(isnull([end date]),DateDiff("d",[Start Date],
Date()),DateDiff("d",[Start Date],[End Date]))

 

[Douglas J. Steele]

Or, perhaps simpler,

DateDiff("d",[Start Date], Nz([End Date], Date()))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

=iif(isnull([end date]),DateDiff("d",[Start Date],
Date()),DateDiff("d",[Start Date],[End Date]))

Hello,

Is there a way in access to have it automatically calculate how many days
have passed between a start date and an end date? And if there is no end
date
yet, how many day have gone by between the start date and today?

 

[Guest]

Wow, that's a lot of useful information there, thanks a lot!
Now I just have to figure out where this goes.