How to Exclude Dates Based on a Date Column?

[cjphoto]

Hey there! I'm trying to figure out how to give my slice a Row Filter that excludes entries that are older than 2 months. I do have a [Date] column in my spreadsheet. Is there an expression I can use to exclude dates older than 2 months in my app based on this column?

[dbaum · Accepted solution]

[Date] >= TODAY() - 60 //date is not earlier than 60 days ago

You can also get more dynamic and precise using other Date and time expressions - AppSheet Help--e.g., older than first day of the month before last.

[cjphoto]

Awesome!! I couldn't figure out how to use TODAY() with [Date] in an expression so this is exactly what I was looking for. Thanks very much and I appreciate the link for more info too!