1 Reply Latest reply on Nov 1, 2018 9:51 AM by Michel Caissie

    Date filter for data prior to current month or for the prior month before the nth day of current month

    Eric Brown

      I have a data source that updates on the 15th day of the month for the month prior.  The following calculated field filters out data for the current month:

      IF MONTH([Date]) = MONTH(TODAY()) AND YEAR([Date]) = YEAR(TODAY())

      THEN 1 ELSE 0 END

      However, I would like to also filter out the data for the month prior when TODAY() is prior to the 15th of the month.

       

      Can anyone help?