Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Home
Discussions
Community Q&A

Dealing with Missing Dates

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

Accepted answers

All comments

Marco_Boeck

Hi,

try this:


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

Regards,
Marco

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups