title: BindingSource Filter by date
body: <p>I want to filter values from database based on date.</p>
  
  <p>Date in a database contains values like this: 2008-12-28 18:00:00. And my class has a DateTime variable depending on which I want to filter. Ideally it would work like this:
  <code>myBindingSource.Filter = "DATE(myDateField) = myDateTime.Date"</code> + adjusting myDateTime.Date format as needed.</p>
  
  <p>But it throws an EvaluateException: "The expression contains undefined function call DATE()."</p>
  
  <p>Although if I execute the SQL statement directly, I can use the DATE() function in filter. </p>
  
  <p>P.S. I use MYSQL DB with the Connector/Net 5.2</p>
  
  <p>How can I solve this problem?</p>
  
  <p>Thank You all for suggestions.</p>