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.