Filter Based on the Last 30, 60, 90 Days

[Anonymous]

I have a column 'Date Complete' that is formatted in the Date type and I need to be able to show a filter on the page to allow the displaying of records that have a 'Date Complete' in the last 30/60/90 days from the current date.

Not sure the best way to do this as I've looked at other posts and havent been able to replicate anything to be able to filter the this way. Any help appreciated.

[Anonymous · Accepted solution]

Hi @Anonymous ,

1. Firstly please make the date column as a slicer

2. Then select the slicer type as "Relative" like below screenshot:

3. Then you can find that you can input last XX days/weeks....

Please try.

Aiolos Zhao