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. 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 |
Example:
Sub
Main
Debug.Print
DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
End Sub