>Hi to all:
>I'm working with the oledb provider for VFP databases and when I insert into a table a date in DD/MM/YYYY format it stores the data in MM/DD/YYYY format althoug I set date to british in the main prg.
>When I read dates ,it works fine but not when I insert new records.
>Some help needed.
>Thanks.
>Pedro

Are you using an 'unambigous' method to specify your date when you save it... either using {^yyyy-mm-dd} or Date(nYear,nMonth,nDay)? These should work irregardless of your date format setting.

BOb