Add a specified time interval to a date.

      DateAdd(interval, number, date)

   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.
Interval Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

DateAdd won't return an invalid date.

The DateAdd() function can be used in VBA or in an SQL query.


In a query:



Add one month to January 31:

DateAdd("m", 1, "31-Jan-16")

In this case, DateAdd returns 29-Feb-16

“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.

Copyright © 1999-2024
Some rights reserved