Sharepoint 2007 Calendar RSS feed in Date Order

[fawkers]

Hello Everyone

My brain might be mush since its friday morning but here goes. I'm trying to take our sharepoint school calendar and display todays items on our digital signage (xibo) using an RSS feed.

Sound good until I realised that the RSS feed is showing items in the order in which they were last edited, not in date order.

Is there a way to sort this out? (and limit the date to today only)

Thanks
Adam

[gpjt]

Hi Fawkers,

Goto the list settings then views, create view.

Rename it whatever you want and you will see in the 2nd column the web address for the RSS feed so keep a note of that. Scroll down to the sort and set that to whatever you want it to be.

To filter it to today, goto the filter section then click on the show items only when the following is true. Set the filter to show the items when the following is true too the column that has the calendar items start date e.g when you view the item whatever your column is that holds the date for the event my columns are called start date. next box is set too is equal to then put [today]

Click on ok.

Then get that RSS feed from the view and just check it in your web browser.

[fawkers]

Hi gpjt,

Thanks, I've created my view however my filter columns dont show the column I whis to filter to (start Tme in my case), i can sort by it but not filter.

any ideas?

[fawkers]

To answer my own question you have to create two calculated fileds for the beging and end date. More information can be found here Filter by "Events this Week" in a SharePoint Calendar | EndUserSharePoint.com

[gpjt]

Beat me to it!
Glad you've sorted it

[sopenshaw]

This worked great for me. But how do you address recurring events?