Search code examples
jquerysharepointspservices

Date comparison is not working in sharepoint spservices

Date Comparission is not working in sharepoint sp services...I want to fetch records greaterthen equal to current year(ie 2013)

   CAMLQuery: "<Query><Where><Geq><FieldRef Name='EventDate' /></Value><Value Type='DateTime' IncludeTimeValue='TRUE'>2013-12-10T12:00:00Z</Value></Geq></Where><OrderBy><FieldRef Name='EventDate' /></OrderBy></Query>",
Solution

  • Try this

    <Query><Where><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>2013-12-10T12:00:00Z</Value></Geq></Where><OrderBy><FieldRef Name='EventDate' /></OrderBy></Query>