Skip to main content
Skip table of contents

DateBetween

Returns if a date is between other two dates.

Syntax

CODE
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

CODE
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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.