I have a sql command:
SELECT * FROM Announce WHERE Deadline>'2003/04/18 14:43:00';
Deadline is a date data type. Now I want to compare 2 different date. However, Access pop a error message: data type mismatch in criteria expression. Can anybody teach me how i do?