>>>>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.
>
>Thanks. Low on brain power here. Is CONVERT() a T-SQL command? I usually use the ANSI CAST or EXTRACT.

PMFJI, but yest it is. It has the same basic functionality as CAST(). It's more akin to the VFP Transform() function because you can also pass a formatting parameter when converting from datetime or money to character (or one of its derivations varchar, nchar, etc.) and get different results.