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
End Sub

See Also:

DateDiff, DatePart.