Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Loving the challenges!
Here is my solution. I used text to columns to parse, then the DateTime tool for the date conversion, and then a couple of select tools to do some housekeeping.
Here was my solution which took extra time mucking around in the DateTime Parse tool to get right. I will definitely look into the ways this can be done in the Formulas tool going forward. Thanks!
Here are my solutions!
Here is my solution to this challenge . I use Text to column tool with formula and date time tool to complete this
Nice easy task to get off the mark.