Problem: I wanted to publish our laundry list of marketing events on our SharePoint Blog. We’re not allowed to do any form of development on our internal SharePoint so I had to make do with a feed reader web part. Unfortunately, it seems like the default behavior of the SharePoint Calendar RSS feed is to sort by date modified.
Solution: Google helped me find this forum http://www.edugeek.net/forums/virtual-learning-platforms/65661-sharepoint-2007-calendar-rss-feed-date-order.html where they talk about the solution but I found there were a few more additional steps of which I will highlight in the walk through below:
2 . I created a view with the Standard View Format as this is only meant to extract the RSS feed from it. Name the view whatever you want and select which columns you want in the feed but what you’ll want to do is scroll down and modify the Sort order. I’ve also modified the Filter so as not to show events in the past.
3. Once you click okay, you should have your view with the correct sorting and filter. This is where it gets a bit tricky. For some reason, even when you have the correct view active, the View RSS Feed on the action Menu doesn’t give you the right feed.
so you’ll have to go to list settings
and click the view you just created to edit it
And click on the RSS Icon, that should give you the correct feed for the view. If you’re in IE (9 as of my testing not sure with the old versions) it automatically sets it to sort by modified date but if you try chrome or the actual feed reader web part, it should give you the correctly sorted/filtered list.