Thanks Cetin.

It seems when I used the DATE type in SQL Server it copied over fine but when I ran the remote view I got Error 2005, a conversion issue. When I disconnected the remote view and ran from local tables the error remained the same. ???

I think the datetime type will work and it seemed to display OK on the VFP forms in the Date field. The only issue was that it rejected any bad date and some date arithmetic code has to be changed. Any further suggestions would be appreciated.

Regards,

Bill