Multiple date formats in one column

[kevinvozza]

Hi all, 

I have one column that contains multiple date formats. I would like to format them all as yyyy-mm-dd but unsure how to convert so many formats. Any help is appreciated. 

Date Formats in Column: 

-  44365 (this format represents 6/11/2021)

-  5/14/2021 0:00

-  3-Oct-21

-  23-07-2021 00:00

[Jayapriya]

Can any one pls help me on above mentioned issue?

[Luke_C]

Hi @Jayapriya 

Switch around the %d and %m in the formula. Those dictate which part of the data is read as a day/month, respectively. I'd also suggest making a new post if that doesn't solve it - that will get addressed quicker by the community. 

[Jayapriya]

Thanks Luke will try the above mentioned method.

Thanks,

JayaPriya M