Hi,

I have following SQLWhereItems code :

if .......... then
SQLWhereItems.Add('DATE_IN IS NOT NULL')
else
SQLWhereItems.Add('DATE_IN IS NULL');

Problem is : the IS NOT NULL part is working well, but IS NULL part doesn't retrieve any records. I checked in the DB and the values are set to NULL.
Is there a better syntax for EMPTY dates ?

Thanks in advance, Nico Callewaert