Hi,

I am trying to calculate the Number of Months a Product has been live
on our Web Site. For this I want to do a datediff between "Product Load
Date" and the last day of the last month of my "Year Month Day"
hierarchy.

My intial attempt is the following:

datediff("m", CDate([Products].[Product Load
Date].CurrentMember.MemberValue),Now())

which only works when you look at all dates. Another problem I have is
that the Dimension Attribute [Products].[Product Load Date] HAS TO be
part of View (as row or Column) but I would like not to show it at all.
I tried to use AVG() on it but it does not work.

Now, I would like to change it so instead of using NOW(), it uses the
Date Dim (Last Day of the Year if looking at it by, last day of Month
when looking at it by Month)

Please help.

Thanks,