In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #4: Date Parsing

DavidP
17 - Castor
17 - Castor

Now I'm all regexed out!

mreynard
7 - Meteor
 
SevenConsulting
6 - Meteoroid
Spoiler
Screen Shot 2018-09-21 at 11.47.18 AM.png

The core of my solution was to parse the different date styles with Regex (I parsed into 5 groupings rather than 3 to handle the 2-digit years, etc easier). I rearranged each grouping to the correct format and converted the alpha months to numeric (YYYY-MM-DD). 

urgatorb8
6 - Meteoroid

Finished

Walsh67
8 - Asteroid

My solution...

LelandM
6 - Meteoroid

Finished

ksheerasagarm
8 - Asteroid

Here is the Solution for Challenge 4

Ladarthure
14 - Magnetar
14 - Magnetar

Number 4, hope one day I'll speak RegEx fluently

krehbieh
6 - Meteoroid

Attached is my solutions. First time using RegEx!

nnilz
8 - Asteroid

solution uploaded