How to Exclude Dates Based on a Date Column?

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?

Solved Solved
0 2 519
1 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.

View solution in original post

2 REPLIES 2