please look at the file i attached where i wan to eliminate nulls in date fields
try like this
if(len(trim(date))>0,Date) as Date
if you want to eliminate the data where date is null then have a where condition like
Hi You can try With multiple way .. depend on your data like
if(IsNull(Date),'Null',Date) as Date OR
Retrieving data ...