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([Measures].[Issue status updated date], Now())
Example bellow will return how many issues, that have been open 14 to 30 days ago from now, are still due.
NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues due] > 0 AND
DateDiffDays([Issue].CurrentMember.get('Created at'),
Now()) >= 14 AND
DateDiffDays([Issue].CurrentMember.get('Created at'),
Now()) < 30
)))
See also
...
Invoice].CurrentMember.getProperty('Invoice date'), Now())