Before Date Query

[Hinfer]

I am trying to do a simple query to count records before the year 1995 and with no education ID. I am having problem with the date expression. Cna some one help?

The date format that appears in the table is yyyy-mmm-dd (2001-Jan-01)

SELECT Count(dbo_patient.patid) AS COUNT, dbo_patient.birthdate
FROM dbo_srvcevnt RIGHT JOIN (dbo_education RIGHT JOIN dbo_patient ON dbo_education.patID = dbo_patient.patid) ON dbo_srvcevnt.clntshid = dbo_patient.patid
WHERE (((dbo_education.educationID) Is Null) AND ((dbo_patient.birthdate)<1995));

 

[nickjar2]

If u r using the Count, don't you need grouping also?

What about the Year function:

Year(yourDate)<1995

Nick