DateAdd

Syntax

DateAdd(interval, number, dateexpr)

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.

See Also

DateDiff, DatePart.

Example

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