Query to compare dates

[Guest_imported]

How do you compare two dates to see how many days have gone by???

 

[lblastick]

Try using the DateDiff function.
Example -
DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])

 

[shiningblade]

You can use the DateDiff function.

Jude

 

[WildHare]

Or try subtracting the first date from the second:

DaysBetween = Date2 - Date1




Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm