Returns a datetime that is the result of adding the specified number of time interval units to the original datetime.
DATEADD(interval, units, datetime)
interval
Specifies the units (year, quarter, month, day, hour, minute, second or week) used to calculate the date addition.
units
Specifies the number of intervals.
datetime
Specifies the date to which the intervals are added.
The following intervals are valid.
YEAR
Returns a date that is the number of years specified from the datetime.
QUARTER
Returns a date that is the number of quarters specified from the datetime.
MONTH
Returns a date that is the number of months specified from the datetime.
WEEK
Returns a date that is the number of weeks specified from the datetime.
DAY
Returns a date that is the number of days specified from the datetime.
HOUR
Returns a date that is the number of hours specified from the datetime.
MINUTE
Returns a date that is the number of minutes specified from the datetime.
SECOND
Returns a date that is the number of seconds specified from the datetime.
DATEADD(MONTH, 3, #8/18/2009#)
11/18/2009
DATEADD(DAY, 365, Sell End Date)
Returns a sell end date for each instance that is 365 days from the original sell end date. For example, if the original sell end date is 12/18/2009, the result is 12/18/2010.
12 December 2006
14 April 2006