Returns if any date from comma separated string is between time period start and end dates.
Syntax
AnyDateInPeriod(dates_string, Time_Member_Expression)
Arguments
dates_string | String with comma separated dates (in YYYY-MM-DD or other recognized format). |
---|---|
Time_Member_Expression | MDX expression that returns Time dimension member. |
Examples
AnyDateInPeriod([Issue].CurrentMember.get('Previous due dates'), [Time].CurrentMember)
will be true if any issue previous due date was in current Time dimension period.