Challenge #58: An Odd String to Date Conversion

[BrandiGSFS]

This is the first time I completed a challenge without looking at other solutions for a hint, so I'm pretty proud of myself but realized I over complicated this, lol. I suck at formulas so this is the long way to go about it. :)

Spoiler

 

[neilgallen]

Regex. Superpower.

[MattKing]

Hi, here is my solution

[svenk]

My Solution!

[Ukashi]

Thank you for challenge:)

Spoiler

[Laurap1228]

I feel like this is the same as challenge #46 ??

Here is my solution in one formula tool with the following function:

Spoiler

DateTimeParse(IF Left([date], 1)="0" THEN "19"+Right([date], 6) ELSE "20"+Right([date], 6)  ENDIF,"%Y%m%d")

[danilang]

Duplicate of Challenge 46

Dan

[willstom1]

Here is my solution:

Spoiler

[JDelgado]

Easy peasy...

[EFran]

Pretty straight froward