Carlos Ventura (CarlosV1753)
Rulesware LLC
Rulesware LLC
CarlosV1753 Member since 2018 6 posts
Rulesware LLC
Posted: March 7, 2019
Last activity: March 7, 2019
Posted: 7 Mar 2019 12:17 EST
Last activity: 7 Mar 2019 14:30 EST

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.

Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.