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
| Time_Unit_String | Time unit that needs to be added |
|---|---|
| yyyy | year |
| q | quarter |
| m | month |
| ww | week |
| d | day |
| h | hour |
| n | minute |
Examples
Add 40 min to the issue creation date
The below formula will add forty minutes to the issue creation date.
DateAdd('n', 40, DateParse([Issue].CurrentMember.Get('Created at')))
Add 1 month to the sprint start date
This formula takes the sprint start date and adds 1 month to it.
DateAdd('m', 1, DateParse([Measures].[Sprint start date]))
Substract 3 days from the issue due date
The below formula will substract 3 days from the issue due date.
DateAdd('d', -3, DateParse([Issue].CurrentHierarchyMember.Get('Due date')))
Substract 1 week from the version release date
This formula takes a version release date and calculates the date that is 1 week before it.
DateAdd('d', -3, DateParse([Issue].CurrentHierarchyMember.Get('Due date')))