6 Replies Latest reply: Apr 3, 2013 9:34 AM by Vijit Jindal RSS

    How can I achieve the common data for the last three months

      I need to get the count of Id's which are having status '2' for the last three months...


      Created three variables to get last three months dates as below


      vMaxmonth = Date(Max(Month_Date),'DD/MM/YYYY')

      vLastmonth = Date(MonthEnd(AddMonths('$(vMaxmonth)',0)),'DD/MM/YYYY')

      vLastmonth2 = Date(MonthEnd(AddMonths('$(vMaxmonth)',-1)),'DD/MM/YYYY')


      and used these variables in chart like this




      but it is giving me all the records, not the common records having status 2 for last three months,


      Anybody please suggest...