>>>Is there a way to convert datetime to date fields in SPT cursor?
>>
>>Would TTOD() do what you want?
>>
>>SELECT TTOD(tMyDateTime) AS dMyDate...
>
>You can only use functions that the back end will understand for SPT. I think CONVERT() may be what's needed here.
CONVERT() doesn't work either because SQL Server doesn't have a date datatype. I posted the same question a couple of days ago and the answer seems to be NO. You can do it with Remote Views, but not SPT cursors.
Bill Armbrecht
VFP MCP