Data type mismatch in criteria expression.

Question

Hi friends,

After tried a lot, finally i came here to find a solution.

       I am getting "Data type mismatch in criteria expression" in the following line.

            OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM ple_rfid_swipelog WHERE RFID_ID=12345 AND ENTRY_DATE=#2010-09-19#", conn);

Please help!

Thanks in advance.