Accessing Calendar List Item in C# using CAML

Question

Hello,

I have a calendar list in my sharepoint publishing site and I am accesing the list items in my server side code.

And all is working fine regarding the fetching.

But the problem is, I want the latest event to be fetched in the code and am using CAML query to achieve this.

But what it's doing is giving me the latest event using the date filter(ie an event scheduled tomorrow).

But what I want is if there is an event which is scheduled Today at some later time from now ,then it should return that event instead of the event occurring tomorrow.

Below is my caml query for the same

query.Query = @"<Where><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>" + today + "</Value></Geq></Where><OrderBy><FieldRef Name='EventDate' Ascending='TRUE' /></OrderBy>";

I have included IncludeTimeValue='TRUE' but no luck.

The event is a recurring event.

Thanks in advance.

Any help will be appreciated..

Regards

Soham

Answer 1

I had the same issue.

This should fix it:

"<Where><And><Geq><FieldRef Name='EventDate' /><Value IncludeTimeValue='TRUE' Type='DateTime'><Today /></Value></Geq><IsNotNull><FieldRef Name='Title' /></IsNotNull></And></Where><OrderBy><FieldRef Name='EventDate' Ascending='True' /></OrderBy>";

let me know if you still have issues.

Answer 2

Thanks for your response but it still doesn't work

It's not fetching my recurring events

One more thing I have both recurring and non recurring events in my calendar list so 

if a recurring event is latest I need to fetch that event and if a non recurring event is latest then i need to fetch that.

For now with the above query I am getting only the latest non recurring event.

Can you suggest anything else?

Thank you

---

Soham Patel

Answer 3

Hey Soham

Glad you were able to square away one issue at least.

Here is a link that can help you address the Recurrence aspect:

http://sharepoint.stackexchange.com/questions/32178/populating-a-simple-custom-event-web-part-that-retrieves-information-from-the-oo

Answer 4

Hello

I have managed to solve the problem and your link was the help that I was looking for.

Many many thanks... :-)

Regards 

Soham

---

Soham Patel

Answer 5

Your welcome!