I have an Event content type with a Date range field. I created a view of events and added an exposed filter for the Date Range field. I used the operator 'is between', so the user can enter a start date and end date to search between.
If the event starts on 1/1/11 at 9am and ends on 1/1/11 at 5pm, I want this event to show up when the user filters for events between 1/1/11 and 1/1/11.
But there are no results unless you change the end date to something greater than 1/1/11. I know this makes sense according to the 'is between' filter but I don't think it will be intuitive for users.
Can anyone help me with a way to make the end date inclusive, so it includes events on the end date specified??
I'm using the datetime_range module, and I've patched it with #60 at https://www.drupal.org/node/2786577 to enable date range filtering with views.
Thank you