🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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