3 Replies Latest reply: Apr 22, 2016 8:14 AM by Sunny Talwar RSS

    Last three months of maximum month of selected date range.

    dhanpal manoj kumar

      Hi ,


      I have a Date coulmn in the format 'MMM-YYYY'.

      Now I want to show the last three months of maximum of selected date range.

      I have done it by using the following expression in text object.




      Where vtemp_date=Date(AddMonths(Max(Date(Date#(CLDR_MMM_YYYY,'MMM-YYYY'),'MM')),-3),'MMM-YYYY').


      I want to know weather there is any other way to achieve the same.