Challenge #58: An Odd String to Date Conversion

[Verakso]

I could have sworn that we have done a weekly challenge like this before, or I am having a Deja Vu.

Anyway, nice with a quick and simple challenge and here is my shot

Spoiler

I could not help notice, that some more clever persons than me, did this using one single formula, but I did get the end result pretty fast, even with all the hoops.

Still Climbing

/Thomas

[NatSnook]

thanks

[Deevi]

PFA my solution.

[cplewis90]

Great challenge

Spoiler

[gradyjofficial]

my solution

[JonathanAllenby]

Here's my solution to challenge 58! (Isn't this exactly the same as challenge 46?)

[sprodger]

Spoiler

[TonyA]

Since this is identical to Challenge #46 and I did my best to minimize the use of formulas in that one, I did this conversion with one formula.

Spoiler

Spoiler

The formula is 
ToDate(IIF(StartsWith([date],"1"), "20", "19") + Substring([date],1,2)+ "-" + Substring([date],3,2) + "-" + Substring([date],5,2))

[AmNotARobot]

I only just completed challenge number 46 the other day; challenge 58 is the same. So skipping on to next 'beginner' challenge.