Check Windows date format settings. We had a problem in Canada where the settings weren't correct.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer