Document toolboxDocument toolbox

DateAdd

Returns the date plus the specified number of the chosen time units.

Syntax

DateAdd(string, number, date)

Arguments


stringTime unit
numberA numeric expression for the number of time units
dateMDX expression that returns a date

You can also use a string expression that can be parsed with DateParse as any date argument.

Time Units

yearyyyy
quarterq
month

m

weekww
dayd
hourh
minuten

Examples

DateAdd('n', 40, DateParse([Issue].CurrentMember.get('Created at')))

The above formula will add forty minutes to the issue creation date.

See also

DateParse