5 Replies Latest reply on Dec 15, 2017 12:33 PM by Vinnie Ahuja

    Date filter to only include dates thru previous month

    Alysse Mea

      How do I make my graph below to show all of 2016 and 2017 will only be from Jan to Nov 2017? So always exclude any dates after previous month of current year.

       

       

       

      I tried:

      If month([Date]) <= month(DATETRUNC('month', today())-1)

      then 'Last Month'

      else 'Not last Month'

      end

       

      Used the calc above to filter to only Last Month but Dec 2016 was not showing. Thanks!