DateAdd: Difference between revisions
Jump to navigation
Jump to search
Created page with "DATEADD(''interval'',''number'',''date'') '''Description''' DATEADD returns the date which is obtained by adding a specified number of date intervals to a given date. The re..." |
No edit summary |
||
| Line 3: | Line 3: | ||
'''Description''' | '''Description''' | ||
DATEADD returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see Table 6 below. The required parameter, number, is any numeric expression that specifies the number of intervals to add.The required parameter, date, can be any expression that represents a date. | DATEADD returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see Table 6 below. The required parameter, ''number'', is any numeric expression that specifies the number of intervals to add.The required parameter, ''date'', can be any expression that represents a date. | ||
'''Table 6: Interval Values''' | '''Table 6: Interval Values''' | ||
Revision as of 02:28, 4 July 2012
DATEADD(interval,number,date)
Description
DATEADD returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see Table 6 below. The required parameter, number, is any numeric expression that specifies the number of intervals to add.The required parameter, date, can be any expression that represents a date.
Table 6: Interval Values
| Value | Description |
|---|---|
| yyyy | Year |
| q | Quarter |
| m | Month |
| y | Day of year |
| d | Day |
| w | Weekday |
| ww | Week of year |
| h | Hour |
| n | Minute |
| s | Second |
Example
REM DATEADD Example
'DATEADD adds date intervals to a date
PRINT "+10 seconds:", DATEADD("s", 10, NOW)
PRINT "-1 year:", DATEADD("yyyy", -1, NOW)
Output
+10 seconds: 8/18/98 10:52:54 PM -1 year: 8/18/97 10:52:44 PM
Related Items