SQL problem

[capone67]

Hi Gang

I am trying to execute an SQL query that has a date in it. I am getting a data type mismatch error using the following code. How do I represent a date in a format that SQL will recognize?

Here is my code.

SELECT count(*)
FROM Schedule
WHERE Hour='0' And MyDate='11/15/2000';


TIA

Ken

 

[cfc]

Try using
SELECT count(*)
FROM Schedule
WHERE Hour='0' And MyDate='#11/15/2000#';


or else

SELECT count(*)
FROM Schedule
WHERE Hour='0' And MyDate=#11/15/2000#;

 

[capone67]

Thanks

This one worked

SELECT count(*)
FROM Schedule
WHERE Hour='0' And MyDate=#11/15/2000#;