>I am trying to convert an application in VFP 7.0 to SQL and use date only field a lot. Do you have some sample code written for transferring data from VFP 7.0 --> MS SQL and how does date field get transferred to SQL ?
>

MS SQL 2008 finally has date data type. Prior to it you'll have to use datetime data type.