Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI used Regex to parse out the year code and the rest of the date information. Then a formula tool to DateTimeParse the strings.
Thanks.
Ta da!
Short & sweet!
I could see this being a bigger challenge if the data had come from multiple sources, including manual keypunches (e.g. what to do with something like this 1040232), but to the original point by GeneR in the challenge post, it does show how quickly some system conversion issues can be solved!
Another one down!
my solution