Thanks Cetin

Is that the only way you know of, it seems quite strange to me as I'm sure I've never had this problem before.

Kev

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