CMS, filters and conditions

Hi all,

I am trying to work out how to sort an events page into date order.
I can do this easily with just selecting filter - oldest - newest… that’s fine.

BUT

Some of these events span over multiple days and some don’t.

Here is an example
Event 1 - 21st May to 2nd June
Event 2 - 3rd June

What happens at the moment is, when the date is in the past (Event 1, 21st May) it disappears. I don’t want it to disappear because the event is still running until 2nd June

So I set up a filter and select [Start Date] is [7 days] [in the past].
That brings up the event listing again… problem solved - but it doesn’t because

That filter will apply to all events, therefore the Event 2 (3rd June), which is only on for one day will still be visible with the current filter settings. I don’t want it to display after 3rd June.

I have been trying to work on all types of permutations but am getting fed up now.
Can any logic wizards out there tell me if there is a solution to this?

Thank you in advance.


https://preview.webflow.com/preview/the-widgeon-theatre-boat?utm_source=the-widgeon-theatre-boat&preview=e4a48a08b4539bbcd039b16ec402a1c7

I am having a similar problem, but I also can’t seem to figure out a good way to get an event to span across multiple dates without creating a million date and time fields. How did you get your events to have multiple dates?