DateAdd Function |
Named Arguments
Yes
Syntax
DateAdd(interval, number, date)
interval
Use: Required
Data Type: String
An expression denoting the interval of time you need to add or subtract (see the table Section 7.52.3).
number
Use: Required
Data Type: Numeric
An expression denoting the number of time intervals you want to add or subtract.
date
Use: Required
Data Type: Date Variant
A Variant of subtype Date or a literal denoting the date on which to base the DateAdd calculation.
Interval Settings
Setting | Description |
---|---|
yyyy | Year |
q | Quarter |
m | Month |
y | Day of year |
d | Day |
w | Weekday |
ww | Week |
h | Hour |
n | Minute |
s | Second |
Return Value
A Variant of subtype Date.
Description
Returns a variant of subtype Date representing the result of adding or subtracting a given number of time periods to or from a given date. For instance, you can calculate the date 178 months before today's date, or the date and time 12,789 minutes from now.
Rules at a Glance
Specify the interval value as a string enclosed in quotation marks (e.g., "ww").
If number is positive, the result is in the future; if number is negative, the result is in the past. (The meaning of "future" and "past" here is relative to date.)
The DateAdd function has a built-in calendar algorithm to prevent it returning an invalid date. For example, you can add 10 minutes to 31 December 1999 23:55, and DateAdd automatically recalculates all elements of the date to return a valid date, in this case, 1 January 2000 00:05. This includes leap years: the ...
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.