Add a specified time interval to a date.
Syntax DateAdd(interval, number, date) Key interval The interval of time to add. number The number of intervals to add. positive for dates in the future or negative for dates in the past. date The date to which the interval is added.
|y||Day of year|
DateAdd won't return an invalid date.
The DateAdd() function can be used in VBA or in an SQL query.
Add one month to January 31:
DateAdd("m", 1, "31-Jan-12")
In this case, DateAdd returns 29-Feb-12
“Beauty is Nature's coin, must not be hoarded, but must be current” ~ John Milton
Date - Return the current date.
DateDiff - Return the time difference between two dates.
DatePart - Return part of a given date.
DateSerial - Return a date given a year, month, and day.