This function adds value to a date.
Parameters:
- Expression. Type: Date.
- Increment type. A string containing one of the following values:
- Second
- Minute
- Hour
- Day
- Week
- Month
- Quarter
- Year
- TenDays
- HalfYear
- Size. The size of the date increment. Type: Number. Fractions are ignored.
DATEADD(DATETIME(2009, 10, 12, 10, 15, 34), "Month", 1)
Result:
11/12/2009 10:15:34 AM
Next page: DATEDIFF