I am using the following to get the current month:
Tail(Filter([Period].[Month].Members,[Measures].currentmember <> 0),1)



How do I get the current month's days?

So 1-30 or 31??



Thanks,


Clint

Sorry, left this out...

So I want all the days in September. I don't want the tail of the last 30
days. Because that may go into the previous month.

AshVsAOD -

Just getting the children of that returned first member of the set should do
it for you, as long as your hierarchy goes from month directly down to day.

Something like:

Tail(Filter([Period].[Month].Members,[Measures].currentmember <>
0),1).item(0).Children

Good luck.

- Phil


"AshVsAOD" wrote:

Thats it!

Thanks for your help.

Cheers