Challenge #58: An Odd String to Date Conversion

[ZacharyRyanTIL]

solved

[ahsanaali]

[karlhansen]

Spoiler

[pmyers]

My solution attached.

[Ruban]

Formula:

IF Left([date], 1) = "1"

THEN Replacefirst([date], Left([date], 1), "20")

ELSE ReplaceFirst([date], Left([date], 1), "19")

ENDIF

[Krzysztof_Ch]

Spoiler

[RMdL]

This challenge is the same as challenge 46 no? Like same file and all! 

Spoiler

[gupta_sahil]

Here is my solution.

[paul_houghton]

Going Fancy in a single tool answer with regex, for the lols

Spoiler

 

[Carolyn]

Solution attached. I did both a formula DateTimeParse and the DateTime tool, to practice both