How did you try to do it?
Which Database are you using?
I seem to recall having to surround dates with #s (#01-JULY-2002#), but that was on Access/SQL-Server. YMMV.

C.