Using Where with dates

[msgb1080]

I am working on a project and I can't get my WHERE statement to work. Here is the code I'm using:

SELECT *
FROM Employee
WHERE EMP_HIREDATE > 1990-01-01
AND EMP_DOB > 1960-01-01;


I am not getting an error, but when I run the query it returns entries out of these ranges.

Any thoughts??

 

[Trevor G]

Are your date fields actual date field data types or string?

The following is an example which is using date fields as the data type and is surrounding the date with # symbols

SELECT tblSession.Bitesize, tblSession.DateAttended
FROM tblSession
WHERE (((tblSession.DateAttended)>#1/1/2011#));

 

[msgb1080]

Adding the # around the dates fixed it!! Thanks.

 

[Trevor G]

Pleased to read you have a solution.