Document toolboxDocument toolbox

Support center for flex.bi version 4.0

DateInPeriod

Returns if date is between time period start and end dates.

Syntax

DateInPeriod(date, Time_Member_Expression)

Arguments

date
Date expression.
Time_Member_Expression
MDX expression that returns Time dimension member.

Examples

DateInPeriod([Invoice].CurrentMember.getProperty('Invoice date'), [Time].CurrentMember) 

Will return true if Invoice date property of current Invoice dimension member is within current Time dimension period.

See also

AnyDateInPeriod