You have two choices:

1. Convert VFP date to a string or number that SQL Server recognizes as a date. See http://msdn2.microsoft.com/en-us/library/ms180878.aspx for more info
2. Use SPT parameters.

ldDate = DATE()
lcSQL = [SELECT * FROM mytable WHERE dtcol = ?ldDate]

>How do I pass a date condition in the where clause of a Select statement using:-
>1) SQLexec()
>2) Cursoradapter.cSelectCmdFilter
>
>How to convert date as simple VFP SQL is not working for SQL Server?