d = DateAdd(interval, number, date)
|interval||(String) Text string that is the interval you want to add:|
yyyy - year
q - quarter
m - month
y - day of year
d - day
w - day of the week
ww - week of year
h - hour
n - minute
s - second
|number||(Long) The number of interval you want to add. The number can either be positive number, for dates in the future, or negative number, for dates in the past.|
|date||(Date) Date to which interval is added.|
The function can be used to add or subtract a specified time interval from a date. For example, it can be used to calculate a date 30 days from today or a time 45 minutes from now.
To add days to date, can be used day of year ("y"), day ("d") or day of the week ("w").
If the computed date is before year 100, then it generates an error.
NewDate = DateAdd("m", 1, "31-Jan-2019")