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.
Solved! Go to 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
Thank you!