I feel like I'm missing something here.
We have a calendar that communicates staff whereabouts (on leave, working from home, etc). The calendar has a list view that needs to display any events that take place either on (ie. 4 hour event during that day, all day event during that day) or during that particular day (ie. if it's the 25th today and the event is 24th-26th, then it should also display).
The filter for Today view is set to:
- Start Time is less than or equal to [Today] AND
- End Time is greater than or equal to [Today]
However, using this filter, an event for today that goes for 4 hours for example, is not displayed when it should be.
An all-day event for the previous day is displayed, when it should not be.
All-day events for the current day or events which start before and end after current day are displayed, which is correct behaviour.
I have a hunch this has something to do with either time zone or the work week definition in Regional Settings, but I'm not sure how the work week influences how filters operate. Or I could be missing a step in my filter logic.