IIF IS Null statement

[czjames87]

I am trying to build a column using the formula below but can't seem to get the null portion to work correctly. I want the new column to read if the first update date is null then use the last update date else use the first update date. Below is what i am using. Any help would be greatly appreciated. 

iif(IsNull([move_event_first_update_dt],([move_event_last_update_dt]),[move_event_first_update_dt]))

[JagdeeshN · Accepted solution]

Hi @czjames87 

Another way of writing this formula is below:-

if isnull(first update date) then

last update date

else first update date

endif

Do let me know if it works.

Best,

Jagdeesh Narayanan

[christine_assaad]

Hi @czjames87 

I believe that your formula is missing a ")" after the IsNnull.

It should be like this: iif(IsNull([move_event_first_update_dt]),[move_event_last_update_dt],[move_event_first_update_dt])

Hope this helps!

[czjames87]

that did it. Thank you.