Returns Time dimension hierarchy level members between two specified dates.
Syntax
Code Block |
---|
Time_Level_Expression.DateMembersBetween(from_date, to_date) |
Arguments
Time_Level_Expression | MDX expression that returns Time dimension hierarchy level. |
---|---|
from_date | Expression that returns the period start date (included) |
to_date | MDX expression that returns a date |
You can use also a string expression, that can be parsed with DateParse, as any date argument.
Examples
Code Block |
---|
Aggregate( |
...
[Time].[Day].DateMembersBetween('30 days ago', 'today') |
...
) |
returns all Time dimension day level members that represent last 30 days, including today.