Returns if a date is between other two dates.
...
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 issue Inovice is created within the last three months.
...