I have a table which contains an event with a start date and end date.
I want to display all data within a selected date range say for instance between 01/06/18 and 30/06/18. my data could look like the following
EventID, Start Date, End Date
1, 01/06/18, 24/06/18
2, 25/06/18, 09/07/18
3, 01/05/18, 29/05/18
4, 13/05/18, 12/06/18
5, 24/05/18, null
If I selected my date range as 01/06/18 to 30/06/18 I would expect to see events 1,2,4 & 5 returned in my table as either the start or end date falls within my selected criteria (event 5 included as essentially the event is still ongoing).
Could anyone help with the easiest way to achieve this please.
I'm not sure how that would work. The user will select a start date and end date within the dashboard and I just want the table to display any events where the start date or end date falls within the range.