How can I make baes filter the enteries with a date range of x days?

Help
1

What I’m trying to do

I try to use bases for like a simple todo list and it works pretty good for me but I would like to filter for like the tasks for this week.
I get it to work to show me tasks for today and open from before that but I don’t understand how to do it for a week.

Things I have tried

my tasks notes all have the field date with just the date (yyyy-mmm-dd)
and to filter the task for today i use “date <= formula.today” and that works flawless. Now i try to make a view for week but I really have no clue what to use.

I hope this makes sense. I have been going through the forum and help but don’t really seem to find anything with a similar setup.

Anyone any ideas?

2

You didn’t way what formula.today you created for the example you gave, and it wasn’t clear what type of “week” (calendar week or set number of days from current day) you’re interested in nor whether to include or exclude dates previous to the week.

So here’s a handful of variations to get you started.

Only this calendar week:

today().format("yw") == date.format("yw")

This calendar week and older:

today().format("yw") >= date.format("yw")

Six days ago until today:

today() - "6d" <= date

Today until six days in the future:

today() <= date && date <= today() + "6d"
3

Thank you so much @dawni this is exactly what i needed.

The last option today until six days in the future is just what I needed and now have other options too.