When working with calendar items created with recurrence patterns, there’s no immediately obvious way through the object model to expose the individual recurrence items. If you create a calendar event with a daily recurrence pattern which generates 6 separate events, you’re only ever given one item when looking for it through code.<\/p>\n
Using CAML, it’s easy to get all 6 items back as individual items through the use of the DateRangesOverlap<\/a> element.<\/p>\n The structure of the DateRangesOverlap<\/em> element looks like:<\/p>\n Possible values here are:<\/p>\n Using the SPQuery<\/a> class you can set the date the above acts upon, so instead of the current date and time it could be a past or future date.<\/p>\n Take a look at the following example:<\/p>\n The important thing to remember when using the DateRangesOverlap<\/em> element is to also set the ExpandRecurrence<\/a> property of your SPQuery<\/em> class to true, otherwise you won’t get any recurring items back when running it.<\/p>\n The example above will query for recurring events and return all that occurred during the month two months prior to the current date.<\/p>\n You’ll also get back any non-recurring item that exists within the specified time period, which includes single all day events and one off calendar entries.<\/p>\n So, based on a CalendarDate of 1 May 2013, specifying Year<\/em> would bring back items that occurred between 1 May 2012 and up to 1 May 2014.<\/p>\n For Now<\/em>, you would get back items between 1 May 2013 and 1 May 2015.<\/p>\n Day and Month should be fairly self explanatory.<\/p>\n Adding the IncludeTimeValue<\/em> attribute to the value node will further filter your results based on the time specified for the CalendarDate<\/a> property, or the current time if this is not set.<\/p>\n","protected":false},"excerpt":{"rendered":" When working with calendar items created with recurrence patterns, there’s no immediately obvious way through the object model to expose the individual recurrence items. If you create a calendar event with a daily recurrence pattern which generates 6 separate events, … Continue reading \r\n
\nWhat this does is bring back any recurring item where the start date (EventDate) and the end date (EndDate) overlap the value specified, which in the above example is Now<\/em><\/p>\n\n
\r\nSPQuery query = new SPQuery();\r\nquery.Query =\r\n \"