Returns number of days from first date to second date.
Syntax
| Code Block |
|---|
...
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 ago was the invoice created.
| Code Block |
|---|
DateDiffDays([Invoice].CurrentMember.getProperty('Invoice date'), Now()) |