Date Filtering Options (Between Dates YTD, MTD)

can you provide a screenshot?

Yep, this is how to do it. Select Advanced Filters and it will default to starting a default filter on the “Where” line, then select your Column > Date, Select “is between”, then select your exact dates from a calendar view. Perfecto!

this would mean you have to constantly change these two specific dates. Instead a function like “from 5 days ago to 5 days from now” would be great.

There seams to be something similar by using the “last week/next week” filters. However they filter out everything that has a timeline which is longer than the timeframe. E.g. started 2 weeks ago but is still ongoing.

Try adding “current” as an additional OR statement in your filter