I have this dates into my DGV:

```
14/06/2012
15/07/2012
16/07/2012
17/07/2012

```

I set the Filter to this: `([supplier_invoice_date] >= '13/07/2012') AND ([supplier_invoice_date] <= '17/07/2012')`

The Filter return this *(All the dates)*:

```
14/06/2012
15/07/2012
16/07/2012
17/07/2012

```

**Another test:**

Filter: `([supplier_invoice_date] >= '15/07/2012') AND ([supplier_invoice_date] <= '17/07/2012')`

Result:

```
    15/07/2012
    16/07/2012
    17/07/2012

```

Filter: `([supplier_invoice_date] < '17/06/2012')`

Result:

```
14/06/2012
15/07/2012
16/07/2012

```

I think it is only taking the days and does not take months.

Here is my 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] >= '13/07/2012') AND ([supplier_invoice_date] <= '17/07/2012')"
invoicesresults_datagrid_search_supplierinvoice.DataSource = MyFilter

```