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.