Dealing with Missing Dates

JEdward
JEdward New Altair Community Member
edited November 5 in Community Q&A
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
Tagged:

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    try this: 

    if(missing(Date), date_now(), Date)
    Regards,
    Marco

Categories