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.