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! Go to 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.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |