>hello!
>i have this table and my date field gets populated by the date a client was added
>supposed i wanna select all my clients based on the year.
>i have a spinner. that gets the year.
>
>im trying to select all from my table where the year = the selected year in the spinner
>
>so i tried
>
>select * from mytable where clients.date_Add=thisform.spinner1.value;
>into cursor kem
>browse
>
>i wasnt expecting it 2 work and it didnt data type mismatch.
>
>can i use the year separately ? or do i hav to enter a start date and end and query in between those two. that ive done before
What 2 means? 2002?
select * from mytable
where clients.date_Add >= date(2000 + thisform.Spinner1.value,1,1)
and Clients.Date_Add < date(2000 + 1 + thisform.Spinner1.value, 1,1)
into cursor kem nofilter
If it's not broken, fix it until it is.
My Blog