Get the date in the New Column and ignore null values

Question

Hello champs,

I have three columns (Extracted_HO_Date1, Extracted_HO_Date2 and Extracted_HO_Date3) and the date will be in any one of these columns. I want to get the date in a new column (Extracted_HO_Date) and ignore the Null values.

I have attached the file showing the desired outcome, can you please help?

Temp_PDF_Output.xlsx

flying008 · Accepted Answer

Hi, @arsalanzaki

Trim(ToString([Extracted_HO_Date1]) + ToString([Extracted_HO_Date2]) + ToString([Extracted_HO_Date3]))