Display Data Within a Date Range

[mgreen76]

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.

[sunny_talwar]

I think what you might need is Interval Match

[mgreen76]

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.

[sunny_talwar]

How are the user selecting the start and end date? in a variable or in a field which has all the dates between the start and end dates?

[mgreen76]

Hi,

Users will select a start and end date from input boxes which would be passed into variables.