>Select * from Distr where (dis_data >= Ctod('01/01/2009')) and (dis_data <= Ctod('11/09/2009')) >>but today, the end date is 09/14/2009 (here in Brasil is 14/09/2009) and the SQL instruction is like this below - 14 is not a month
>Select * from Distr where (dis_data >= Ctod('01/01/2009')) and (dis_data <= Ctod('14/09/2009')) >>
>Select * from Distr where (dis_data >= Date(2009,09,01)) and (dis_data <= Date(2009,09,14)) >
Select * from Distr where (dis_data >= {^2009-01-01} and dis_data <= {^2009-09-11}) Select * from Distr where (dis_data >= {^2009-09-01} and dis_data <= {^2009-09-14})