Returns number of days from first date to second date.

Syntax

DateDiffDays(from_date, to_date)
CODE

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'), Now())
CODE