Streaming live at 10am (PST)

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

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