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