title: Filtering Dates in FireDac TTable
body: <p>I'm having a problem using TTable in FireDac to filter on a date field.</p>
  
  <p>The database in MySQL/InnoDB. The field is of type Date.</p>
  
  <p>The code I am using to set the filter is </p>
  
  <pre><code>Filter := 'date = ' + QuotedStr(FormatDateTime('mm/dd/yyyy', Date));
  Filtered := True; 
  </code></pre>
  
  <p>Every time I either get an error when setting the filter: "EConvertError with message 'Could not parse SQL TimeStamp string'" or the filter fails to find any records.</p>
  
  <p>The above format is for my current regional settings. I've also tried 'yyyy-mm-dd'. And I've tried both both with and without quotes.</p>