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

    Condition to Display only last 4 month.

    Supriya R

      Hi,

       

      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.

       

      LOAD

          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