>Hi.
>I am trying to popuate a sql server table Data time field from a foxpro table
>I have set Set date British or Set Date american before creating the fields
>(Some are string fields and some are character fields)
> I want to populate
>This all works fine on my PC but when I deploy to client's site,
> the datas are all mixed up (getting the Days/Months wrong)
>
>Is there something else I need to check
>I am using TTOC(DTOT(MyDate))
>Regards,
>Gerard

And how do you populate them?
If the VFP field is date or datetime use parameters or use so called ISO format:
YYYYMMDD HH:MM:SS.
SQL Server always recognize that format no matter what setting it have. Also if you use parameters the VFP will handle the transformation for you.