Challenge #58: An Odd String to Date Conversion

[Walsh67]

My solution...

[ebarrus]

My solution

[ivoller]

I found this pretty straightforward. Went with a formula but I'll come back to see if I can do it with regex

Spoiler

new field with date format and formula - iif(left([date],1)="1","20","19")+Substring([date],1,2)+"-"+Substring([date],3,2)+"-"+Substring([date],5,2)

[ivoller]

I managed to come up with a regex solution. Not pretty or practicable but an interesting exercise in conditional replacement.

Spoiler

REGEX_Replace([date], "^(1)?(0)?(\d{2})(\d{2})(\d{2})$", "(?{1}20$2$3:19$3)-$4-$5")

[mdgajes1]

Done. Took me a few minutes to work out a formula. Its different than the solution's. Always interesting to see how many ways there are.

[aditi_bala]

Inaugural challenge - I enjoyed it!

[JoBen]

Cheers!