>>>>>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.
>>
>>yea but im not going to hard code the year. so the yea can only be one value which is the value it gets from the spinner
>
>LOL.
why u laughed!!! tell me :(