If it helps, end the date component using a format of YYYYMMDD. SQL Server will always read it in the format regardless of the setting of SET DATEFORMAT.

-Mike

>Hi,
>
>Is there a function i can use to convert a Datetime field in visual foxpro to the format used by Sql Server 2000
>
>i.e.
>VFP Format : 03/04/2003 15:30:21
>Sql Format : 2003-04-03 15:30:21
>
>
>Tnx
>Anthi