selecting dates from a particular year 1

[Delboy14]

I am trying to select records from a particular year, the fromat of the field is dd/mm/yyyy. I would like to select records with a date field >=2002. ie. only records enetered from this year onwards, does anyone know how to do this? I have tried:

WHERE datediff('y',2002,ConsultDate)<=0;

WHERE datediff('y',01/01/2002,ConsultDate)<=0;

WHERE ConsultDate>=01/01/2002;

but alll of these do not work does anyone have an idea? thanks in advance

 

[ldandy]

Try WHERE Year(ConsultDate) >= 2002

 

[DJN]

You could also try DatePart(&quot;yyyy&quot;,[ConsultDate])>=2002

 

[Delboy14]

thats it working thanks