Challenge #58: An Odd String to Date Conversion

[Kanishkas5301]

Spoiler

 

Probably not the most efficient way to do this but it works 

[davidhe]

Easy, peasy, lemon-squeezy

Spoiler

[allwynthomas24]

Spoiler

[LiuZhang]

Spoiler

[alishadhillon__]

Alteryx was weirdly cutting off my last digit after the formula so I had to output as a new column, convert and then deselect the old in the select tool.

 Got there in the end though!

[rockyw9]

See solution attached.

[ubifriends]

[SarahJ1]

I broke mine down into quite a few steps compared to other solutions - but as long as you get to the answer guess it doesn't matter!

[juliabarale002]

[jjrbondoc]

Spoiler

DateTimeParse(Switch(Left([date],1),'','0','19','1','20') + Right([date],6),'%Y%m%d')