DateAdd

From NSB App Studio
Revision as of 20:35, 8 August 2012 by Brendon (talk | contribs)
Jump to navigation Jump to search

DateADdd(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

DATEDIFF, DATEPART