>>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.