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

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