Caml Query on calendar to get the next x events (including recurring)

Question

So far I'm able to get the next x events (without recurring events). Code:

    private SPListItemCollection GetNextEvents(SPList eventCalendar)
    {
        DateTime currentDateTime = DateTime.Now;
        string currentDateTimeString = SPUtility.CreateISO8601DateTimeFromSystemDateTime(currentDateTime);
        SPQuery query = new SPQuery();
        query.RowLimit = 3;
        query.ExpandRecurrence = true;            
        query.Query = "<Where>" +                    
                          "<And>" +
                            "<Geq>" +
                                "<FieldRef Name='EndDate' />" +
                                "<Value Type='DateTime' IncludeTimeValue='True'>" +
                                    currentDateTimeString +
                                "</Value>" +
                            "</Geq>" +
                            "<Geq>" +
                                "<FieldRef Name='EventDate' />" +
                                "<Value Type='DateTime' IncludeTimeValue='True'>" +
                                    currentDateTimeString +
                                "</Value>" +
                            "</Geq>" +
                          "</And>" +
                        "</Where>" +
                        "<OrderBy>" +
                            "<FieldRef Name='EventDate' />" +
                        "</OrderBy>";            

        SPListItemCollection itemColl = eventCalendar.GetItems(query);

        return itemColl;
    }

Setting query.ExpandRecurrence = true didn't help. I also tried the solution suggested here. Somehow I can't get it working with recurring events. For the following example I'd like to get the 2nd and 3rd "OK Repeating Event" and the "OK1" event since it starts earlier than "OK2"

Answer 1

Apart from setting ExpandRecurrence property of SPQuery to true, you also need to specify the DateRangesOverlap in the query to get the recurrence events. Example:

SPList list = web.Lists["Company Calendar"];                                       
SPQuery oQuery = new SPQuery();
oQuery.ExpandRecurrence = true;                     
oQuery.Query = "<Where><DateRangesOverlap><FieldRef Name='EventDate' />" +
"<FieldRef Name='EndDate' /><FieldRef Name='RecurrenceID' />" +
"<Value Type='DateTime'><Now /></Value>" +
"</DateRangesOverlap></Where>";                     
oQuery.CalendarDate = DateTime.Now;                    
SPListItemCollection items = list.GetItems(oQuery);                    
foreach(SPListItem item in items)
{
    Console.WriteLine("Title: {0}, StartDate: {1}", item.Title, item["EventDate"]);
} 

See Recurring Calendar Events for more information.