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.

       

      =vtemp_date&Chr(10)&Date(AddMonths(vtemp_date,1),'MMM-YYYY'&Chr(10))&Date(AddMonths(vtemp_date,2),'MMM-YYYY')

       

      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.