Filtering a view based on week

[a_fatima]

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.

[Steve]

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:

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

[DBook]

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)))