Problem retriving data from access
I am using C# as the language for programming .I am accessing table in the access database . The table has three fields EmpName(text), FromDate(DateTime) and ToDate(DateTime). I am getting error while executing reader .
The Query string is
SELECT * FROM EmpLeaveApproved WHERE EmpName LIKE 'Akhil Vira' AND FromDate BETWEEN '1/1/1999' AND '1/1/2000';
The error message that i am getting is
Data type mismatch in criteria expression.
Can anybody please point out were i am making mistake
Thanks in advance