6 Replies Latest reply: May 15, 2012 8:49 AM by Kaushik Solanki RSS

    Need to display financial monthyear



      I want to display financial month-year formate of my date field.my financila year is Apr-Mar.

      i am using following script,

      date(monthstart(Date field name), 'MMM-YYYY') AS MonthYear

      but it is displaying 'Apr-2012' but i want to display 'Apr-2013' when clicking on the Apr month.i used lot of syntax but it is not correct.

      can any one have idea...