DateInPeriod
Returns if date is between time period start and end dates.
Syntax
CODE
DateInPeriod(date, Time_Member_Expression)
Arguments
date | Date expression. |
---|---|
Time_Member_Expression | MDX expression that returns Time dimension member. |
Examples
CODE
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.