DateAdd

Changes the specified date by the specified interval and number; for example, by adding three days.

Syntax

DateAdd(Interval, N, Date)

Interval

The time interval to change the Date by. This parameter supports the following values:

yyyy: year
q: quarter
m: month
y: day of year
d: day
w: weekday
ww: week
h: hour
n: minute
s: 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.

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"))`]