>Hi
>
>When I pass an INSERT-SQL like "INSERT INTO Table (DateField) VALUES ({15/01/2003})" via ADO Connection, VFP always places the date into the table as an American style format.
>
>I have SET DATE TO British set via the DBC OpenData event, what else can I do?
>
>Thanks
>Kev
Kevin,
Use strictdate format :
"INSERT INTO Table (DateField) VALUES ({^2003/01/15})"
Cetin