calculating time waiting

[dbertanjoli]

Hello, in my form I have two fields: date booked (surgery) and wait time. I would like my wait time field to caculate days someone is waiting for surgery based on date booked and today?

Many thanks,
Debbie

 

[pbaldy]

Sure; look at the DateDiff function in Help.

 

[dbertanjoli]

many thanks, but how to used datediff to calucate days and months of wait based on date booked?

Deb

 

[MSAccessRookie]

Format for datediff

Assuming DateBooked is a Date/Time variable type, you could use the following:

datediff({Interval}, DateBooked, SecondDate) WHERE

Interval is:

"d" for day
"ww" for week
"m" for Month
"y" for Year

would give you the time between the two dates. There are additional intervals as well