Dealing with Missing Dates

JEdward

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

Hi,

try this:

if(missing(Date), date_now(), Date)

Regards,
Marco