Dealing with Missing Dates

User: "JEdward"
JEdward
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

AI Studio
Sort by:
1 - 1 of 11
    User: "Marco_Boeck"
    Marco_Boeck
    New Altair Community Member
    Hi,

    try this: 

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