In load set today date if empty

[#1]

Hi

I have a EndField that are empty if it´s still in progress. For those I want to mark with today date  today ()

Like this: In a other table the endfield are marked with with 99999999 for the post that are still active. There I use this fomula. 

Date(if(EndField2= 99999999, Today(), Date#(EndField2, 'YYYYMMDD')), 'YYYY-MM-DD') as EndField2,

How to do it if it´s empty?

If it´s to any help the table with the empty endfield all empty post are marked as 0 in i other field, named XXX34

[giakoum · Accepted solution]

IsNull(expr )

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

or

Date(if(XXX34= 0, Today(), Date#(EndField2, 'YYYYMMDD')), 'YYYY-MM-DD') as EndField2,

strange field names...

[swuehl]

Or

if( len(trim(EndField2))=0, ....

works also with blank fields or fields that contain only (soft) spaces.