Returns if a date is between other two dates.
Syntax
...
Code Block |
---|
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
Code Block |
---|
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.
...