title: RowFilter using Dates VB.NET
body: <p>I have this dates into my DGV:</p>
  
  <pre><code>14/06/2012
  15/07/2012
  16/07/2012
  17/07/2012
  </code></pre>
  
  <p>I set the Filter to this: <code>([supplier_invoice_date] &gt;= '13/07/2012') AND ([supplier_invoice_date] &lt;= '17/07/2012')</code></p>
  
  <p>The Filter return this <em>(All the dates)</em>:</p>
  
  <pre><code>14/06/2012
  15/07/2012
  16/07/2012
  17/07/2012
  </code></pre>
  
  <p><strong>Another test:</strong></p>
  
  <p>Filter: <code>([supplier_invoice_date] &gt;= '15/07/2012') AND ([supplier_invoice_date] &lt;= '17/07/2012')</code></p>
  
  <p>Result:</p>
  
  <pre><code>    15/07/2012
      16/07/2012
      17/07/2012
  </code></pre>
  
  <p>Filter: <code>([supplier_invoice_date] &lt; '17/06/2012')</code></p>
  
  <p>Result:</p>
  
  <pre><code>14/06/2012
  15/07/2012
  16/07/2012
  </code></pre>
  
  <p>I think it is only taking the days and does not take months.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Dim dt As New DataTable
  Dim suppliersinvoices_data_query As String = ("DATE_FORMAT(MIN(supplier_invoice_date), '%d/%m/%Y') AS supplier_invoice_date, ...")
  Dim invoice_objDataAdapter As New MySqlDataAdapter(suppliersinvoices_data_query, objConn)
  invoice_objDataAdapter.Fill(dt)
  
  Dim MyFilter As New DataView(dt)
  MyFilter.RowFilter = "([supplier_invoice_date] &gt;= '13/07/2012') AND ([supplier_invoice_date] &lt;= '17/07/2012')"
  invoicesresults_datagrid_search_supplierinvoice.DataSource = MyFilter
  </code></pre>