5 Replies Latest reply: Mar 8, 2013 8:05 AM by Kaushik Solanki RSS

    Month Year in Expression

      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!!!