Date compare Question..>Datamismatch

[nellis10]

OK by now you ar eprobably sick of my simple questions BUT this one is really bugging me cause I don't know the reasoning behind the Date set up.

I have test dates in the format 11-Jan-00.

I want to get all details from tests who's date where between 01-Jan-00 and 31-Jan-00.

My code is like this:

SELECT clientNo, testdate
FROM Driving_Test
WHERE testresult = 'Pass' AND testdate BETWEEN '01-Jan-00' AND '31-Jan-00";

But when I try to run it it gives me a data mismatched expression error thingy! If I just do it on the Pass result it works, so its something to do with the date.
Why doesn't it recognise the date format?

Thanks chaps/chapesses

natalie

 

[Nouba]

try using # as date limiter instead of (').

hth nouba

 

[nellis10]

Thanks that works!!!

I was pulling my hair out for ages on that one!!