Challenge #4: Date Parsing

[jon_m_nakamoto]

I took a slightly different tack from the posted solution (still haven't waded through that RegEx!) -- wanted to be able to handle other likely date formats (e.g., 12-14-58, 9/9/91, January 4, 2001) -- the posted solution won't handle these. Also wanted to allow anyone in the future to convert two digit years to the most likely four digit years even if they use this years from now, so used a DateTimeNow (so if you run this in 2045, 12/14/30 will convert to 2030-12-14).

[Chantelbbr]

Just starting out with Regex. This was fun practice!

Spoiler

[sachinw]

My Solution:

[Billigans]

Spoiler

Feel like I cheated a bit here because I had to steal the RegEx code from the solution. From there I created a single formula to move all the dates into a single column and then used the BB Date Tool (which everyone should download) to do all the date formatting for me. 



Oh well, all roads lead to Rome, I guess. 

[JSchiele]

Definitely the long way but it works!

[Jean-Balteryx]

Here is my solution !

[ArnavS]

RegEx had me scratching my head quite a bit on this one

[Kaviyarasan_P]

Completed, I have used DateTimeParse in the formula tool.

[ejparth]

solution.... nice challenge ...learnt so many tools