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 :=


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]