title: How to specify ODATA filter query for the salesforce connector in Microsoft Flow
body: <p>I'm having difficulty determining the correct format for a date (not a datetime) expression. In this situation, CloseDate from the Opportunity table.</p>
  
  <p>I have tried multiple formats, including quotes, no quotes, timezones, no timezones.  I have this working in regular REST queries just using the date in format yyyy-MM-dd without quotes, </p>
  
  <p>A couple of examples..</p>
  
  <p><strong>CloseDate le 2011-12-31</strong></p>
  
  <p>ERROR: <em>Salesforce failed to complete task: Message: FROM Opportunity WHERE (CloseDate &lt;= 2011-12-31T00:00:00.0000000+00:00)\n                                       ^\nERROR at Row:1:Column:6368\nvalue of filter criterion for field 'CloseDate' must be of type date and should not be enclosed in quotes\r\nclientRequestId: 50c8ea4a-bd02-4e95-919c-df02074f3144",</em></p>
  
  <p><strong>CloseDate ge '2017-01-01'</strong> </p>
  
  <p>ERROR: <em>value of filter criterion for field 'CloseDate' must be of type date and should not be enclosed in quotes</em></p>
  
  <p><strong>CloseDate ge datetime'2017-01-01'</strong></p>
  
  <p>ERROR: <em>inner exception: Unrecognized 'Edm.String' literal</em></p>
  
  <p>Help!  Has anyone worked out how to specify the format for a "date" field in an ODATA filter?</p>
  
  <p>Many thanks in advance.</p>