4 Replies Latest reply on Feb 15, 2019 9:52 AM by albert wong

    Set dynamic filter for year(date)

    Rose K

      Hello,

       

         I would like to know the logic to show default filter for last 2 years dynamically. Currently I've set filter manually to show 2017 & 2018. But I would like to show 2018 and 2019 now which I would like to show dynamically.

       

      I've tried this formula but this shows 2017 and 2018.

       

      DATEDIFF('year',[Date of Service],TODAY())>0

      AND

      DATEDIFF('year',[Date of Service],TODAY())<=2

       

      Any suggestions & insights would help. Appreciate your help!

       

       

      Thank You!