Challenge #58: An Odd String to Date Conversion

[ebostwick]

Same as challenge 46, but I tried a one-tool solution this time.

Spoiler

 

[chriswilliams41]

I need to be doing these, so here I go. Let's roll. 

[RasmusFormo]

Spoiler

[Rob-Silk]

My solution below - same as Challenge 46 so decided to do it as a single Formula tool version this time

Spoiler

Formula: DateTimeParse(IIF(Left([date], 1) = "1", "20", "19") + Right([date], Length([date]) - 1), "%Y%m%d")

[logdog0411]

Spoiler

 

[jennifer_owens]

attached

[SanjeevDosanjh]

Spoiler

 

[snbandi]

My solution

[SidSaythongphet]

Spoiler

 

[alfredcsy]