Dealing with Missing Dates

Question

Hi,

I'm trying to replace missing (NULL) values in a date field with today's date.  
I first tried a GenerateAttributes operator using IF(MIssing(fieldname),date_now(),fieldname), but this threw a syntax error.

Anyone have any suggestions?

Thanks

Marco_Boeck · Answer

Hi,

try this:
if(missing(Date), date_now(), Date)

Regards,
Marco