DateAdd Function

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

See Also            DateDiff, DatePart.

Example            '#Language "WWB-COM"
Sub Main
    Debug.Print DateAdd("yyyy",1,#1/1/2000#) '1/1/2001
EndSub