DateMembersBetween
- Elvis Kvalbergs
- Gvido
Owned by Elvis Kvalbergs
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_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
Aggregate(
[Time].[Day].DateMembersBetween('30 days ago', 'today')
)
returns all Time dimension day level members that represent last 30 days, including today.