DateDiff Function

Syntax:
DateDiff(inteval, 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. If this value is Null then Null is returned.
dateexpr2 Calculate the from dateexpr1 to this date value. If this value is Null then Null is returned.
Interval Description

yyyy Year

Quarter

m Month
d Day
w Weekday
ww Week
h Hour
n Minute
s Second
See Also: DateAdd, DatePart.
Example:

Sub Main
Debug.Print DateDiff("yyyy",#1/1/1990#,#1/1/2000#) ' 10
End Sub