DateBetween

Returns if a date is between other two dates.

Syntax

CODE

DateBetween(date, from_date , to_date)

date	MDX expression that returns a date
from_date	MDX expression that returns a date
to_date	MDX expression that returns a date

You can use also a string expression, that can be parsed with DateParse, as any date argument.

CODE

DateBetween(
 [Invoice].CurrentMember.getProperty('Invoice date'),
 '3 month ago',
 Now()
)

The above formula will be true if an Inovice is created within the last three months.