Month Year in Expression

[#1]

I want to show only a specifc Month year in an expression based on todays date.  So if today date is 03/07/2013, I want the expression to show on Mar 2013 data.  Below works

Sum({<CalendarWrittenYear = {2013}>} Subtotal)

But I need something like

Sum({<CalendarMonthandYear= {Today}>} Subtotal)

So the CalendatMonthandYear is Mar 2013, I need to convert today into Mar 2013.

Help!!!

[jagan]

Hi,

Try this

=Sum({<CalendatMonthandYear={"=$(=Month(Today()) & ' '&Year(Today())"} >} Subtotal)

Hope this helps you.

Regards,

Jagan.

[#3]

Does not want to work, the expression says it is OK, but I get no data.

Lance H. James, CPA

Director of Finance

The Aspen Brands Company

Kate Aspen · Baby Aspen

678.282.0053 x 777

<http://www.theaspenbrands.com/>

<http://www.kateaspen.com/>

<http://www.babyaspen.com/>

[#4]

How is the field CalendarMonthandYear formatted in your data? I guess it can be a little different that jagan mohan assumed (e.g. 'March 2013')

[#5]

I am usind the calendar app to help with the dates, the dates are first 3 letter of the month, followed by space then year.  So 03/04/2014 would be "Mar 2013"

[kaushiknsolanki]

Try to create MonthYear as follows.

Monthname(Date) as CalendarMonthandYear

Then you can use below expression in chart to get the desired result.

Sum({<CalendarMonthandYear= {"$(=monthname(Today()))"}>} Subtotal)

Regards,

Kaushik Solanki