DateCompare
EAZYBI Returns -1 if first date is less than second date, 1 if first date is greater than second date, and 0 if dates are equal..
Syntax
DateCompare(date, date_to_compare)
Arguments
date | MDX expression that returns date |
|---|---|
date_to_compare | MDX expression that returns date |
You can use also a string expression, that can be parsed with DateParse, as any date argument.
Examples
DateCompare([Issue].CurrentMember.get('Due date'), "Today")
The formula will return -1 if due date of the issue is before Today, 0 if an issue is due Today, and 1 if an issue due date is after Today. See example report Issues due and overdue in our demo account. The calculated measure Issues due in time uses the formula above to check if issue is not due yet and a similar comparison with resolution date for resolved issues before due date.