If you use SPT parameters, VFP will do conversion for you

ldDate = DATE()
lcSql = [INSERT INTO SqlTable VALUES (?ldDate)]

>I am converting a VFP table with date fields to a SQL server table with DateTime fields . (I am assumiong the DateTime field is the correct type of field ?)
>I am using the Insert SQLEXEC command... how do I convert the VFP date field to a SQL DateTime field ?