Subject Re: NULL Date values
Author jeff_j_dunlap
Here is a code snippet showing how I am obtaining the date values, null
or otherwise:

SELECT DateToStr(INITIALCONTACTDT, '%m.%d.%y') FROM LEADS WHERE IDNO
= '325'

if (st->Fetch())
st->Get(1, sInitialContactDt);

sInitialContactDt contains the date if available. If the date is NULL,
rFunc's DateToStr function returns 11.17.4294967254

I am really confused why DateToStr() returns the value above when it
encounters a NULL date. Am I not supposed to allow NULL date values
into FB?

Please advise,

Jeff