Challenge #414: Mastering Date Formats

[Luke_C]

Spoiler

[emmaob98]

File:

[braveraj]

Spoiler

[Watermark]

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

Spoiler

 

[ArisaOkada]

Here's my solution!

Spoiler

[sergejs_kutkovics]

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

Nice challenge, @AntobennetshaJ! Thank you!

Spoiler

[Rob-Silk]

Solution attached below:

Spoiler

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:

Spoiler

[Chris-Nienart]

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

Spoiler

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

[balajilolla2]

Spoiler

Solution Attached