DateAdd
Returns the date plus the specified number of the chosen time units.
Syntax
DateAdd(Time_Unit_String, Number_Expression, Date_Expression)
Arguments
Time_Unit_String | Time unit that needs to be added. |
---|---|
Number_Expression | A numeric expression for the number of time units that need to be added. |
Date_Expression | MDX expression that returns a date to which the time units will be added. |
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.