Filtering a view based on week

AppSheet AppSheet Q&A
,
1

Hi,
I am trying to create a view which shows tasks from last week and this week. Is there a way to show both the past week and this weeks tasks in one single view.

2

You’ll need to base your view on a slice with a row filter expression that includes only the desired rows.

  1. Since the most recent Sunday: ([Date] > (TODAY() - WEEKDAY(TODAY())))

  2. Since the most recent Monday: ([Date] > (TODAY() - WEEKDAY(TODAY()) + 1))

  3. Within the past seven days: ([Date] > (TODAY() - 7))

Since a week prior to the above:

  1. Since a week ago Sunday: ([Date] > (TODAY() - WEEKDAY(TODAY()) - 7))

  2. Since a week ago Monday: ([Date] > (TODAY() - WEEKDAY(TODAY()) + 1 - 7))

  3. Within the past 14 days: ([Date] > (TODAY() - 14))

See also:

3

I was trying to make a slice to display only the last 30 days out of a much larger table… could be 7 could be 365, whatever. At first I tried Steve’s expression, but it does not work.

This expression does work:

AND( ([DATE] >= TODAY()), ([DATE] <= (TODAY() - 30)))