DateAdd
Changes the specified date by the specified interval and number; for example, by adding three days.
Syntax
DateAdd(Interval, N, Date)
Parameters
Interval
The time interval to change the Date
by. This parameter supports the
following values:
yyyy
: yearq
: quarterm
: monthy
: day of yeard
: dayw
: weekdayww
: weekh
: hourn
: minutes
: second
N
The number of Interval
to add to the Date
; for example, three days.
This value may be positive or negative.
Date
The date to change by the specified Interval
and number.
Example
The following example subtracts one day from 2007-07-05:
[DateCustom].[DateInt].[DayInt].&[`Year("2007-07-05T12:30:10")`]&[`Month("2007-07-05T12:30:10")`]&[`Day(DateAdd("d",-1,"2007-07-05T12:30:10"))`]