Any way to filter on not just date but date AND time with CMS collection list wrapper?

Design help CMS
1

Hi there! As mentioned in the title, is there any way to filter on not just date but date AND time with a CMS collection list wrapper?

Let’s say I have a site where the CMS holds a list of events — some are coming up, some are happening now, and some will eventually be over. I want to have one section of my site hold all the events that are currently happening (so events where the Current Date/Time is later than or equal to the Event Start Date/Time but before the Event End Date/Time). I want to have another section of my site hold all the upcoming events (so any event where the Current Date/Time is before the Event Start Date/Time of the event).

From what I can tell, if all my events were to start and end at midnight, the CMS filters would work just fine. The issue is that the events will be starting an ending at various times of day.

With that, if the current date/time is October 28, 2021 at 12:45 PM ET and I have an event that begins at October 28, 2021 at 9:00 PM ET, it doesn’t seem like there’s a way to have the event properly move from the upcoming events section to the current events section with the clock strikes 9:00 PM ET.

Any ideas?

I made a very quick sample site to provide an example of this.

Here is my public share link: LINK

2

Hi, did you ever find out a way to do this?

3

I have the same issue. We show a list of webinars, and we sometimes have several per day. We want the next upcoming webinar to display in a banner on the homepage, and would like it to be replaced as soon as the event end time passes.

Currently it only filters on date (not time), so it will show a 9am webinar for the entire day, even if there’s a 12pm and 2pm on the same day.