Filter by last 90 Days

Hello,

Sorry for the basic question, but trying to filter rows to only show rows where the date listed is 90 days older than today's date.

Tried [field name]=(DateTimeToday(),-90)"days" but thats not quite working.

The date field format is YYYY-MM-DD HH:MM:SS

Thanks for the help.

Date Time

Accepted answers

Try this formula into the filter tool to filter exactly the row with date = datetimetoday() - 90:

datetimediff(datetimetoday(), [date], 'days') = 90

If you want to keep everything equal or older than 90 days, use this one:

datetimediff(datetimetoday(), [date], 'days') >= 90

Try this formula into the filter tool to filter exactly the row with date = datetimetoday() - 90:

datetimediff(datetimetoday(), [date], 'days') = 90

If you want to keep everything equal or older than 90 days, use this one:

datetimediff(datetimetoday(), [date], 'days') >= 90

@AG50 One way of doing this

Thank you!