The dateDiff functionis what you need
Returns the number of intervals between two dates.
DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])
Arguments
interval (you want to put 'h' for hour)
Required. String expression that is the interval you want to use to calculate the differences between date1 and date2.
date1, date2 (put your two dates here)
Required. Date expressions. Two dates you want to use in the calculation.
firstdayofweek
Optional. Constant that specifies the day of the week. If not specified, Sunday is assumed.
firstweekofyear
Optional. Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.
Wind is your friend
Matt
|