If you are looking for other options, I think a sort order by Original Post Title would be the most flexible. You would have to title the events YYYY-MM-DD to get them to sort properly. You could manually pin the upcoming events and set the “pinned until” date to automatically unpin them.
Discussed with screenshot at Sort topics within category by topic title