Subject How to keep null dates null?
Author Clay Shannon
I have a table with some dates stored as <null>.



However, when I update any changes the user may have made:



if not TryStrToDate(iwedtAdmissionDate.Text, d8Admit) then

d8Admit :=
FIBDatasetCaseEdit.Fields.FieldByName('ADMIT_DATE').AsDateTime;

.

sp.ParamByName('ADMIT_DATE').AsDate := d8Admit;



if the user hasn't made any valid changes (for example, the direct
assignment to d8Admit above is executed if iwedtAdmissionDate.Text = ''),
the dates in question are changed from null to 0 (12/30/1899), so that the
records display that bogus date instead of blank as before when the value
was <null>.



How can I prevent this from happening?



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]