I am working on C# programming to read Sharepoint and want to query the calendar event after a time point, such as Today.
CamlQuery query = new CamlQuery();
query.ViewXml =
" ....
<Query>
<DateRangesOverlap>
<Where>
<Gt>
<FieldRef Name='EventDate'/><Value Type='DateTime' IncludeTimeValue='TRUE'><Today/></Value>
</Gt>
</Where>
</DateRangesOverlap>
...";
1. With <DateRangesOverlap> I got all events including Recurrence events but not based on time filter; Looks like <Where> is totally ignored.
<Query>
<Where>
<Gt>
<FieldRef Name='EventDate'/><Value Type='DateTime' IncludeTimeValue='TRUE'>" <Now> </Value>
</Gt>
</Where>
2. Without <DateRangesOverlap> I got the events with appropriate right time filter, but no Recurrence events;
How can I get the main events and including the Recurrence events with the time filter?
Thanks;
Iris;