Challenge #4: Date Parsing

[aheikes]

Spoiler

[atcodedog05]

On a spree to binge complete weekly challenges

Spoiler

I approached by eliminating each format at a time. 

[avinashsunchu]

Spoiler

 

[Ashley2]

Challenge 14 Complete!!

My Solution;

Spoiler

[JonMcMillin]

Reg Ex to the rescue!

Spoiler

[jjlauman]

I'm sure there are more efficient ways to do this, but it was an excellent refresher on regular expressions!

My solution is attached.

[Normster]

This one has so far been the most difficult for me.  (This is my 24th one).  For whatever reason, my formulas didn't work as expected, even when I pared them down to the most basic (e.g. IF Contains THEN etc.).  I therefore had to create a formula for each modification.  Very frustrating and time consuming.  I still got to the same end point but it was rough.

I spent a lot of time thinking about how to solve this in real life.  The question graciously provided the different date formats and there were only 17 records.  What if the dataset was larger and no date info was provided?  

Anyway, my cobbled together workflow is attached.  I look forward to any comments.  Thanks.

Normster

[Lavanya_kommuri]

My solution

[MichaelSu]

Series of RegEx & DateTime Tools. See attached.

[kenhermosura]

Not pretty but gets the job done.