3 Replies Latest reply: Aug 14, 2016 6:53 AM by Kaushik Solanki RSS

    Condition to Display only last 4 month.

    Supriya R



      I am trying to display only last 4 months.


      so for thaat I have Canonical_Month in script, which contains all 2015 and 2016 months.



          Date(CanonicalDate, 'MM-DD-YYYY') AS CanonicalDate,

      Month(CanonicalDate) As Canonical_Month;


      Now i need only last 4 months irrespective of year.


      How could i do this? Any help is appreciated