Join Dates from 8 different columns

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

Date input.xlsx

Datasets

Input

Regex

Output

Parse

Preparation

Accepted answers

binu_acs

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

Join_Dates_23062025.yxzp

All comments

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.

Community_0623_1.yxmd

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 ?

RMR output.xlsx

binu_acs

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

Join_Dates_23062025.yxzp

AnanditaShankar

Thanks @binu_acs

Quick Links

This months top contributors

mceleavey 383

AkimasaKajitani 382

mbarone 337

Hollingsworth 335

LanisC 335