Message
From
23/03/2010 13:49:32
To
23/03/2010 13:43:48
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Miscellaneous
ID da thread:
01456639
ID da mensagem:
01456675
Views:
25
>>Try first
>>
>
>
>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.
>>
>>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.