>>Try first
>>
>>select * from myTable where datefield >=date(2002,1,1) and datefiled < (2003,1,1)
>>
>>Does it bring you records? If not, in means all records are deleted or don't exists for the year 2002.
>
>
>i changed the months seemd to fix it
You didn't need to change months if you wanted the whole year. Look closer at the solution presented.
If it's not broken, fix it until it is.
My Blog