>>According to VFP help, the SET DATE Command is not supported by VFP OLE DB Provider. Sorry for confusion.
>>
>>Why do you need to change date format for VFP OLE DB provider?
>
>Becouse until friday my application worked with this
>

>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'))
>

>
>So, if I can change the date format to DMY, I don't neet to change all the application to
>

>Select * from Distr where (dis_data >= Date(2009,09,01)) and (dis_data <= Date(2009,09,14))
>

Can you use parameters instead? Or use the format Boris suggested.