Returns the date plus the specified number of the chosen time units.
Syntax
DateAdd(string, number, date)
Arguments
|
string |
Time unit |
|---|---|
|
number |
A numeric expression for the number of time units |
|
date |
MDX expression that returns a date |
You can also use a string expression that can be parsed with DateParse as any date argument.
Time Units
|
year |
yyyy |
|---|---|
|
quarter |
q |
|
month |
m |
|
week |
ww |
|
day |
d |
|
hour |
h |
|
minute |
n |
Examples
DateAdd('n', 40, DateParse([Issue].CurrentMember.get('Created at')))
The above formula will add forty minutes to the issue creation date.