GET the date from multiple columns

Column1	Column2	Columne3	Output
[Null]	31Dec20	23	31Dec20
31Mar2020	32	LoremIpsum	31Mar20

Hello, I have 3 columns and output is going to get the date between three columns, however the date format between all three columns are different some have (%d%b%y) and some have (%d%b%Y). Just different in year some have 2020 and some have only 20.

Workflow

Tips and Tricks

Accepted answers

Qiu

@Ultralightbeam
Your month was 3-characters only. Now modified to any length of characters.

0112-Ultralightbeam.yxmd

All comments

Emil_Kos

Hi @Ultralightbeam,

I have prepared a workflow for you.

First, we create proper date formula using:

DateTimeParse([Column1],"%d%b%Y")

After we got 3 date columns I am using the max function to pick the correct date.

The output. You need to clean it but it will help you understand how this was achieved.

Max date.yxmd

Ultralightbeam

Hi, thanks for your help however, I still need to retain the formatting of date if it is 2020 or 20 as you can see on row 2 it was 31Mar2020 and should still be 31Mar2020 and not 31Mar20

Qiu

@Ultralightbeam
Maybe this is what you need.

0112-Ultralightbeam.yxmd

Ultralightbeam

@Qiu the output should not be transformed. It still should be 31Mar2020

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703