DateBetween

EAZYBI Returns if a date is between other two dates.

Syntax

 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(
  [Issue].CurrentHierarchyMember.Get('Created at'),
  '3 month ago',
  Now()
)

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

See also