Challenge #2: Preparing Delimited Data

[Evanachi]

Challenge 2

[iakovidc]

Spoiler

[Razzle]

Loving the challenges!

[Sntrada]

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.  

[StellaBon]

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!

[dsaikat]

Solved

[evw19]

Here are my solutions!

[vaishabhinav_iitm]

[Faaiz26]

Here is my solution to this challenge . I use Text to column tool with formula and date time tool to complete this

[DavidWebb]

Nice easy task to get off the mark.