Set default filtering for past two years counting from current date
We have a requirement in which the business needs to display cases from the past two years based on a date property. For example if I'm generating the report on March 07,2019 it should display cases from March 07,2017 until today. Also the user should be able to expand the date range to show all cases or any other range.
Any idea or suggestion in how to do this?
I added a filter where I calculate the difference in days with the current date and if it less than 731 days then the row is included and hid the filter. I thought that the out of the box filtering for that column would override to let the user modify the range but I was wrong.