hi
i am getting an error like
<br />
<br />
Data type mismatch in criteria expression.<br />
<br />
i am using wpf (windows application in C#.net )
iam using the access2003 as the database
i had tried as below
OleDbConnection mcon = new OleDbConnection("provider =Microsoft.JET.OLEDB.4.0;data source=D:\\invoice\\invoice.mdb");
OleDbCommand da = new OleDbCommand("select companyname,customername from invoicetable where date BETWEEN '&11/11/1975&' AND '&11/11/2004&' order by ID desc", mcon);
OleDbDataReader dr;
mcon.Open();
dr = da.ExecuteReader();
and also i had trind in this way also
OleDbCommand da = new OleDbCommand("select companyname,customername from invoicetable where date BETWEEN '11/11/1975' AND '11/11/2004' order by ID desc", mcon);
in access database in am saving in date formate like 'mm/dd/yyyy' in shortformate
what is the error that i am doing, please help me
thankq for ur attention thank's a lot