Challenge #414: Mastering Date Formats

[Luke_C]

スポイラ

[emmaob98]

File:

[braveraj]

スポイラ

[Watermark]

Went a little over dynamic/flexible, and created it where could handle any quantity in any order. 

スポイラ

 

[ArisaOkada]

Here's my solution!

スポイラ

[sergejs_kutkovics]

My try! I nod't like IF formulas :)

Nice challenge, @AntobennetshaJ! Thank you!

スポイラ

[Rob-Silk]

Solution attached below:

スポイラ

I tried to keep it as dynamic as possible so split out the date string and format string, then standardise, both before using  them in the DateTimeParse() function

[kelvin_law1]

Here is my solution:

スポイラ

[Chris-Nienart]

I don't have context but that '1920' date makes me suspicious whether it was actually supposed to be '2020'.

スポイラ

A table of replacement values can make this workflow more reuseable and readable than data cleansing in a formula tool.

[balajilolla2]

スポイラ

Solution Attached