DateDiff Function
Syntax
DateDiff(interval, dateexpr1, dateexpr2)
Group
Time/Date
Description
Return the number of intervals between two dates.
| Parameters
|
Description
|
| interval
|
This string value indicates which kind of interval to subtract.
|
| dateexpr1
|
Calculate the interval from this date value to dateexpr2.
If this value is Null then Null
is returned.
|
| dateexpr2
|
Calculate the interval from dateexpr1 to this date value.
If this value is Null then Null
is returned.
|
| 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
Sub Main
Debug.Print DateDiff("yyyy",#1/1/1990#,#1/1/2000#) ' 10
End Sub