Date Row Filter in Slice

[lala_land]

Hi, in my app, I would like to slice filter the [Date] column showing rows with date of past 7 days and the next 7 days.
For example,
If the date is “1/18/2022” in the [Date] column,
then I will be able to see row with date from “1/11/2022” to “1/18/2022” and “1/18/2022” to “1/25/2022”.

What is the formula that I can input or use?

[Marc_Dillon · Accepted solution]

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.