Skip to main content
Skip table of contents

DateDiffDays

Returns number of days from first date to second date.

Syntax

CODE
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
DateDiffDays([Invoice].CurrentMember.getProperty('Invoice date'), Now())
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.