DateAdd
Changes the specified date by the specified interval and number; for example, by adding three days.
note
DateAdd can be used in calculated measures.
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, and can optionally be substituted with a measure.
Date
The date to change by the specified Interval
and number. This value can optionally be substituted with a measure.
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"))`]
The following expression illustrates using DateAdd over a measure:
DATEADD("d", 1, [Measures].[MinOrderDate])