Say I have a cpt “events”, and these events will happen on multiple dates. I then add a repeater (event_dates_repeater) so that I can add all the dates (event_date) in which the event will take place. I want to query these posts on a page so that the next event that’ll happen will always be the first shown. However, having multiple dates inside a repeater, it would have to work in such a way that when the first date of an event is already done, the query would now orderby the second closest date after $today.
I do understand how to order a query by a specific meta_key, but I’m not sure how to filter this meta just to use the next closest date subfield after today.