Join Dates from 8 different columns

[AnanditaShankar]

Hi ,

I want to create one single date column from 8 different date columns in the excel attached. For eg : if  '[month-year]" column is Blank then it should be replaced with one of the dates from other 7 columns . Now this '[month-year]" column is a string so after creating that it should be converted to date format and arranged chronologically. I tried it with multifield formula below :

IF [month-year]= "NULL" THEN [Input_#2_month-year] ELSEIF [Input_#3_month-year] ELSEIF [Input_#4_month-year] ELSEIF [Input_#5_month-year]ELSEIF [Input_#6_month-year]ELSEIF [Input_#7_month-year]ELSEIF [Input_#8_month-year] ELSE [month-year] ENDIF

This didn't work. Any help would be appreciated. Thanks in advance

[Yoshiro_Fujimori]

Hi @AnanditaShankar 

If you want to select the earliest date in each row, here is a proposal.

You may change Min_Value to Max_Value in Summarize Tool if you want the latest date instead.

I hope this helps.

[AnanditaShankar]

Thanks @Yoshiro_Fujimori . This logic works when I am just using month-year columns as input. But my file also has some other columns so it is creating duplicate values when I am trying to integrate it. Attaching the actual file . Could you help me apply the same logic here ?

[binuacs · Accepted solution]

@AnanditaShankar one way of doing this with the help of dynamic select tool

[AnanditaShankar]

Thanks @binuacs