datagridview select query from string to date

**minanakhla** · Jun 15 '14, 04:27 AM

Hi

I am using access database , vb.net
to filter my datagridview I used

Code:

Sales_ItemsDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_Items.Select(("Convert(category, 'System.String') LIKE '" & search2 & "'")

now my problem
my date is string in the Database
date format is 31/12/2001
and i want to filter the dategridview between 2 dates so i uesed

Code:

Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.Select(("Convert(invoice_date, 'System.String')  <= '" & DateTimePicker2.Value & "' AND Convert(invoice_date, 'System.String')   >= '" & DateTimePicker1.Value & "'"))

but sure that gave me funny results as it considered the date as string...
but i failed to change the

Code:

("Convert(invoice_date, 'System.String')

to date format
can any one help Please.....