Simple formula that's killing me, I need a new date column that pulls in values from three date columns when one is null, date order matters so I'll put them in order below New Date ColumnDate 1Date 2Date 301/05/201801/05/2018 05/16/2017 05/16/2017 05/09/201705/09/2017 11/21/2018 11/21/2018 My thought was something like New Date Column = IF ISNull(Date 1) THEN (Date 2) ELSEIF ISNull(Date2) THEN (Date 3) else (Date 1) endif I know I messing that up a bit but any help would be greatly appreciated. Cheers!

Multiple ISNull()

Simple formula that's killing me, I need a new date column that pulls in values from three date columns when one is null, date order matters so I'll put them in order below

New Date Column	Date 1	Date 2	Date 3
01/05/2018	01/05/2018
05/16/2017		05/16/2017
05/09/2017	05/09/2017
11/21/2018			11/21/2018

My thought was something like

New Date Column =

IF ISNull(Date 1)

THEN (Date 2)

ELSEIF ISNull(Date2)

THEN (Date 3)

else (Date 1)

endif

I know I messing that up a bit but any help would be greatly appreciated.

Cheers!

Tips and Tricks

Accepted answers

JosephSerpis

Hi @dlopez I came up with an alternative approach let me know what you think? I also amended your code to work for the provided example.

Dates_05112020.yxmd

All comments

JosephSerpis

Hi @dlopez I came up with an alternative approach let me know what you think? I also amended your code to work for the provided example.

Dates_05112020.yxmd

dlopez

@JosephSerpis

Worked like a charm, thanks Joseph!

Cheers,

david

Christine_Assaad

Hello @dlopez

You can achieve your goal in many ways:

Formula:

Transpose - Filter and Join for more robust solution in case you have more than 3 fields

Fill in the date.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703