sharepoint DateRangesOverlap - find overlaping items for a date range

Question

Hi Folks,

I am looking for a sample syntax to identify what items overlap with my calendar entry.

We have a Calendar list in Sharepoint. I would like to build a custom query for identifying overlaping items for the "new" calendar entry.

It looks like DateRangesOverlap is what I would need , but its not clear for me , how to set it up with the date range . For example :

My new meeting is from monday to wednesday this week. sharepoint , please give me all the items that overlap with "monday to Wednesday this week"

thanks, Gabor

Answer 1

DateRangesOverlap is not what you want, despite the name.

Its used behind the scenes to support the calendar views when an instance of a recurring event would fall in the Day/Week or Month views so it only works with and in the CAML.

(for extra confusion note that when using Month its not the calendar month but what would show on a calendar view of that month - so for July 2010 it would be 28th June to 1st August.)