Filter by last 90 Days

[AG50]

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. 

[Felipe_Ribeir0 · Accepted solution]

Hi @AG50 

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

[binuacs]

@AG50 One way of doing this

[AG50]

Thank you!