I want to pass a string(date) in a caml query to get listitem based on datetime type of field. I am not getting any value in return. Please suggest. Below is my code:

` private SP.ListItem FindListItem(List selectedList, Field field, string value, ClientContext clientContext)
        SP.ListItem listItem = null;
        CamlQuery camlQuery = new CamlQuery();
        if (field.TypeAsString == "DateTime")
            DateTime datevalue = Convert.ToDateTime(value);
            camlQuery.ViewXml = @"<View><Query><Where><Eq><FieldRef Name=" + field.InternalName + @"/><Value Type=" + field.TypeAsString + @">" + datevalue + @"</Value></Eq></Where></Query></View>";                               

        SP.ListItemCollection items = selectedList.GetItems(camlQuery);
        if (items.Count > 0)
            listItem = items[0];

        return listItem;

4 Answers 4


You have to convert your DateTime object to a ISO8601 format. You can use the SPUtility class.


string datevalue = SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(value));


As far as Client-Side Object Model (CSOM), versus Server Side,


string datevalue = SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(value));


You would need to use the string formatter,

string datevalue = Convert.ToDateTime(value).ToString("yyyy-MM-ddTHH:mm:ssZ");

As far as the performance optimizations, suggested by the other individual, there are some suggestions, at the following page using CSOM, Point #5, on how to reduce the number of round trips to the server, and increase performance.

  • Is it possible to use SPUtility in Client Object Model? Mar 10, 2016 at 13:43
  • I had updated answer, immediately following your comment yesterday. Mar 11, 2016 at 15:27

You have to convert your DateTime object to a ISO8601 format using SPUtility class. and then pass it to Caml query.

string Iso8601Today = XmlConvert.ToString(DateTime.Now, XmlDateTimeSerializationMode.Local);

Replace DateTime.Now with your "value".


  • Is it possible to use SPUtility in Client Object Model? Mar 10, 2016 at 14:10
  • 1
    You can use Utility Class in CSOM. If you want to achieve the same date in CSOM then, you should use string formattedDate = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ssZ"); Mar 11, 2016 at 5:42

get listitems without query , clientContext.ExecuteQuery(); after do your limitation by converting your string to date. this can be reduce performance.


I usually use a function to convert a date to ISO Date.

function ISODateString(d){
  function pad(n){return n<10 ? '0'+n : n}
  return d.getUTCFullYear()+'-'
      + pad(d.getUTCMonth()+1)+'-'
      + pad(d.getUTCDate())+'T'
      + pad(d.getUTCHours())+':'
      + pad(d.getUTCMinutes())+':'
      + pad(d.getUTCSeconds())+'Z'

Then you use like that:

var desde = ISODateString(Pdesde);
var hasta = ISODateString(Phasta);

And the CAML is:

'<Query><Where><And><Leq><FieldRef Name="Fecha"/><Value Type="DateTime" IncludeTimeValue="TRUE">' + hasta + '</Value></Leq><Geq><FieldRef Name="Fecha"/><Value Type="DateTime" IncludeTimeValue="FALSE">' + desde + '</Value></Geq></And></Where></Query>'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.