In order to use SQL Server 2008 from VFP with T-SQL and Date field types you will need to use driver={SQL Server Native Client 10.0} which doesn't support varchar(max) field type. You have to use text field types which will eventually be deprecated.
Brandon Harker
Sebae Data Solutions