Syntax DateAdd(interval, number, dateexpr)
Group Time/Date
Description Return a Date value a number of intervals from another date.
Parameter Description
interval This string value indicates which kind of interval to add.
number Add this many intervals. Use a negative value to get an earlier date.
dateexpr Calculate the new date relative 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 DateDiff, DatePart.
Example '#Language "WWB.NET"
SubMain
Debug.Print
DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
EndSub