DateAdd Function

Syntax

DateAdd(interval, number, dateexpr)

Group

Time/Date

Description

Return a Date value a number of intervals from another date.

Parameters

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
q Second

See also

DateDiff, DatePart


Sub Main
    Debug.Print DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
End Sub