DateAddDays
EAZYBI Returns date plus a specified number of days.
Syntax
DateAddDays(Date_Expression, Numeric_Expression)
Arguments
Date_Expression | MDX expression that returns a date to which the days will be added. |
---|---|
Numeric_Expression | Integer expression for a number of days to add. |
Examples
DateAddDays([Issue].CurrentHierarchyMember.GetDate('Created at'), 90)
See the report example Blocker Story Plan (Bar as Gantt) in our Demo account. The calculated member Issue end date uses the formula above to set the planned end date for an issue with no due date.