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.
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.