Skip to main content

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: 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.

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