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