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:


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