Syntax DateDiff(interval, dateexpr1, dateexpr2)
Group Time/Date
Description Return the number of intervals between two dates.
Parameter Description
interval This string value indicates which kind of interval to subtract.
dateexpr1 Calculate the from this date value to dateexpr2.
dateexpr2 Calculate the from dateexpr1 to this date value.
Interval Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second
See Also DateAdd, DatePart.
Example '#Language
"WWB.NET"
SubMain
Debug.Print
DateDiff("yyyy",#1/1/1990#,#1/1/2000#) ' 10
EndSub