> With this code, I get a data mismatch error.
Paste the exact text.
Some compilers report "can't convert <sometype> to <someothertype>"
Knowing what the types actually are (how you declared things) might make it a lot easier to tell you how to fix it.

Some declarations would help as well, we can't psychicly guess what you wrote.

06-04-2006

ctid

Here is the entire block of code. The database it is getting the info from is an MS Access database and the rented field is a Date/Time datatype.