Returns number of days from first date to second date.
...
 DateDiffDays(from_date, to_date)
Arguments
from_date | MDX expression that returns a date. |
|---|---|
to_date | MDX expression that returns a date. |
Examples
Following example calculates how many days has the issue been in current statusago was the invoice created.
DateDiffDays([MeasuresInvoice].[Issue status updatedCurrentMember.getProperty('Invoice date]'), Now())
Example bellow will return how many issues, that have been open 14 to 30 days ago from now, are still due.
...