Date conversion issue

[Anjankumar2021]

Hi  All,

could some one assist on Date conversion issue?

i see some of them converted into a date format YYYY-MM-DD , but we need all dates should converted to one unique format or no change format. pls refer to the attached excel. kindly assist

[Bren_Spill]

@Anjankumar2021 - can you elaborate on this and provide more specific details of what you want to convert?

[mkeiffer]

@Anjankumar2021  There are probably a lot of different ways you could approach this, but I did it with a couple of formulas and I think this is producing the desired output. 

[Qiu]

@Anjankumar2021 
Weekly challenge #414 is all about Date Time Parsing.

I am sure you can do it after checking it.

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-414-Mastering-Date-Formats/td-p/1242461