DateAdd Function
Syntax
DateAdd(interval, number, dateexpr)
Group
Time/Date
Description
Return a Date value a number of intervals from another date.
Parameters
|
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.
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
DateDiff, DatePart
Sub Main
Debug.Print DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
End Sub