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.
...