Returns number of days from first date to second date.
Syntax
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.
DateDiffDays([Invoice].CurrentMember.getProperty('Invoice date'), "today")