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

    Set dynamic filter for year(date)

    Rose K



         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


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


      Any suggestions & insights would help. Appreciate your help!



      Thank You!