DateAdd Function

Syntax:

DateAdd(interval, number, dateexpr)

Group:

Time/Date

Description: 

Returns a date value a number of intervals from another date.

Parameters:

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
EndSub

See Also:

DateDiff, DatePart.