title: SharePoint CSOM Query Keyword Filter On Date Time Type Column
body: <p>I am using the <strong>CSOM SharePoint</strong> client library fom a Desktop c# application to interact with SharePoint.</p>
  
  <p>I would like the do a <strong>query</strong> based on a <strong>date and time type column</strong> being of a certain date time and to return the matching document data.</p>
  
  <p>If I enter the text LastModifiedTime: 2019-11-19 into the SharePoint search box, results are returned so I know there is matching data in SharePoint.</p>
  
  <p>If I set the <strong>KeyWorkQuery</strong> to be a query on a string based column the expected results are returned.</p>
  
  <pre><code>KeywordQuery keywordQuery = new KeywordQuery(context);
  keywordQuery.QueryText =  @"author: ""Tom"" author: ""Bill"" FileType: ""txt""";
  </code></pre>
  
  <p>To filter on a column that is a datetime type I have tried the following and I am not getting the data back.
  I suspect this is a format error in the query text and the query is being treated as a string, as opposed to being of type datetime,</p>
  
  <pre><code>keywordQuery.QueryText = "LastModifiedTime:2019-11-19T09:28:25:ssZ";
  keywordQuery.QueryText = "LastModifiedTime:2019-11-19T09:28:25";
  keywordQuery.QueryText = "LastModifiedTime:2019-11-19";
  </code></pre>
  
  <p>Can the SharePoint client library be used to query on date time type based columns?</p>
  
  <p>If so, what format does the QueryString need to be so that column can be filtered on?
  Any suggestions appreciated.</p>