Document toolboxDocument toolbox

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