I’m wondering how to filter items by start date and due date so that the user will see only items that happen within the current day or week.
For example, say I have three tasks spanning the following start and end dates:
Oct 23 - Nov 6
July 1 - Dec 31
Sept 23 - Nov 1
I want to show only tasks that exist as open on Nov 4. I was filtering based on start and end dates initially, but that would exclude tasks like the Jul 1 - Dec 31 task. Is there a way to filter so that the user can see open tasks at a certain point in time?