>>Does anyone know how to turn a DateTime type field to a Date type field in a SQLEXEC cursor, not a remote view?
>>
>>TIA
>>
>>MOnTe
>
>Have you looked at TTOD() or TTOC()?

I am changing the SQLEXEC cursor to allow updates. The date column in the cursor can be changed in a grid and you cannot update a calculated column (e.g. TTOD(closed_date)). Basically, I want to do to a SQLEXEC cursor what you can already do to a remote view like with the following command:
DBSetProp('rvClosed.closed_date', 'Field', 'DataType', "D")

Any other ideas?