9.0

131
ww Week
h Hour
n Minute
s Second
See Also: DateDiff, DatePart.
Example
Sub Main
Debug
.Print DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
End
Sub
DateDiff Function
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. 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
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
Sub Main
Debug
.Print DateDiff("yyyy",#1/1/1990#,#1/1/2000#) ' 10
End
Sub