[BUG] RSS Feed puts future dated events first

[stockholmux]

Describe the bug

On the valkey slack there is an integration which automatically displays blog post based on RSS. I noticed that the Valkey swift blog didn't show up. Examining the RSS feed, it orders the Keyspace event and contributor summit (August 24, 28) as newer compared to the Valkey Swift (August 4). For most RSS readers, they will only pick up new posts, and, since Swift was before the events, it didn't get posted.

To Reproduce
see above

Expected behavior

The RSS feeds only show posts on the current day or before (or there is a specific feed for events and blog posts)

Screenshots

n/a

Host/Environment (please complete the following information):
n/a

Additional context
n/a