title: c# bindingsource filter by datetime
body: <p>The problem I'm having is that the filter will not accept the time part of a datetime.</p>
  
  <p>For clarity,</p>
  
  <p>This works.</p>
  
  <pre><code>" AND NextWorkDate &lt;= #" + DateTime.Now.AddDays(1).ToString("dd.M.yyyy") + "#"
  </code></pre>
  
  <p>This doesnt work.</p>
  
  <pre><code>" AND NextWorkDate &lt;= #" + DateTime.Now.AddDays(1).ToString("dd.M.yyyy H:mm:ss") + "#"
  </code></pre>
  
  <p>Whenever I try to include the time aspect of the datetime, the filter just doesnt work, it returns no rows.</p>
  
  <p>I've tried it a thousand different ways and I really cant figure out why it won't take the damn time.</p>
  
  <p>The datasource column that the filter is comparing to is a datetime with the format dd.M.yyyy H:mm:ss.</p>
  
  <p>The database column is formatted completely differently, as yyyy-mm-dd hh:mm:ss:fff</p>
  
  <p>Could this be causing some problem along the line? I think it isn't because the filter is applied to the datasource, not the database.</p>