Challenge #4: Date Parsing

[mat_budden]

Hi All,

This one was tricky,

Spoiler

Used Regex and Formulas to extract the date then used Datetime to parse it.

Thanks

Mat

[ZenonH]

Time to take a break

Spoiler

[nini]

My Solution:

[EdwinYakop]

My Solution. Regex is an amazing tools

[Sebenius]

Spoiler

 

[SueDonim]

Getting better at date parsing and a little better at RegEx!!!

Spoiler

Process:
- 4 different RegEx statements to pull out each of the 4 types of date formats
- DateTimeParse in first instance as couldn't make it work in DateTime tool
- DateTime tool in other 3 cases
- Merged the 4 temporary date column into one
- Clean-up results

[AMansour]

Spoiler