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!