I had a need to be able to show up a row if a date in that row had fallen out of compliance, e.g. list of assets, with a “Last Patch” date on it. If the “Last Patch” date is more than X days (e.g. 90 days) before today, then show it up.
At the time of writing there is a feature request in for being able to do NOT “in the last” X “days”, but currently that is not available.
So you can use a formula to do this, so create a formula then you create the filter as shown to refer to the “Last Patch” column or whatever you want to call it.
IF(FORMAT_DATE({Last Patch},"YYYYMMDD")<FORMAT_DATE(SUBTRACT_DAYS(TODAY(),90),"YYYYMMDD"),"Attention","OK")Now you can use that column in whatever normal filter you wish!