Hello,

you can use the ConversionFunc property of the CursorAdapter.

e.g.

DEFINE CLASS yourCA AS yourCABaseClass
SelectCmd = "SELECT someField, someDate FROM someTable WHERE ..."
ConversionFunc = "someDate SQLDateFix"
.. other properties ..
ENDDEFINE


FUNCTION SQLDateFix(ldDate)
RETURN IIF(EMPTY(ldDate),.NULL.,ldDate)
ENDFUNC


this way you don't have to fiddle with this stuff in the user interface and keep the code where it really belong's to (the data layer)

Regards
Christian