Apr 2, 2002 #1 Guest_imported New member Jan 1, 1970 0 How do you compare two dates to see how many days have gone by???
Apr 2, 2002 #2 lblastick Programmer Jan 24, 2002 18 US Try using the DateDiff function. Example - DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate]) Upvote 0 Downvote
Try using the DateDiff function. Example - DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])
Apr 2, 2002 #3 shiningblade Programmer Jan 25, 2002 25 CA You can use the DateDiff function. Jude Upvote 0 Downvote
Apr 3, 2002 #4 WildHare MIS Mar 1, 2002 1,801 US 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/jmhareMore Neat Access stuff at http://www.jmhare.com/wildhare2.htm Upvote 0 Downvote
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/jmhareMore Neat Access stuff at http://www.jmhare.com/wildhare2.htm