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

See also