Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: example

Returns if a date is between other two dates.

...

 DateBetween(date, from_date , to_date)

Arguments

dateMDX expression that returns a date
from_dateMDX expression that returns a date
to_dateMDX 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.

...