Returns if a date is between other two dates.
Syntax
DateBetween(date, from_date , to_date)
Arguments
| 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.
Examples
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.