Document toolboxDocument toolbox

DateMembersBetween

Returns Time dimension hierarchy level members between two specified dates.

Syntax

Time_Level_Expression.DateMembersBetween(from_date, to_date)

Arguments

Time_Level_Expression

MDX expression that returns Time dimension hierarchy level.
from_dateExpression that returns the period start date (included)
to_dateMDX expression that returns a date

You can use also a string expression, that can be parsed with DateParse, as any date argument.

Examples

Aggregate(
  [Time].[Day].DateMembersBetween('30 days ago', 'today')
)

returns all Time dimension day level members that represent last 30 days, including today.