Don't mess with trying to figure out SQL Server's date format. If you're going to send a datetime to SQL Server as a string, format it as YYYYMMDD. No matter how SQL Server is configured, this format will always be intrepreted correctly.

-Mike

>I'm using VFP 7 as front end and MsSQL 2000 as back end. When users run my application and a date is pushed to SQL, depending on there regional setting (Date format),it will fail.
>
>ex:
>SQL Dateformat is Set to MDY and the user local machine is set to DMY format it will fail.
>
>How can I get programaticly the SQL DATE format?