title: Filter WinForms DataGridView by date range
body: <p>I would like to filter my DataGridView by a date range which is listed below.</p>
  
  <p>I have a ListBox with 2 items with start and end date. Start date on top, end date below in listbox.</p>
  
  <p><img src="https://i.stack.imgur.com/5s9xh.png" alt="listbox = lbSearchByTime"></p>
  
  <p>ListBox</p>
  
  <p><img src="https://i.stack.imgur.com/51Mxv.png" alt="DataGridView with column named &#39;DATE&#39;"></p>
  
  <p>DataGridView with date column named <code>'DATE'</code></p>
  
  <p>Note: all DateTime formats in my DataGridView and ListBox are <code>dd/MM/yyyy</code>, example: <code>05/23/2013</code></p>
  
  <pre><code>Filter = "(DATE &gt;= '" + lbSearchByTime.Items[0].ToString().Trim() + 
           "and DATE &lt;= '" + lbSearchByTime.Items[1].ToString().Trim() + "')";
  
  Filter = "(DATE &gt;= '" + Convert.ToDateTime(lbSearchByTime.Items[0].ToString().Trim()) +
           and "DATE &lt;= '" + Convert.ToDateTime(lbSearchByTime.Items[1].ToString().Trim()) + "')";
  </code></pre>
  
  <p>These 2 codes does not work for me. Is it wrong format or something else?
  It does not have any change when perform filter by button_click.</p>