>>>>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.
If it's not broken, fix it until it is.
My Blog