In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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

WillH
7 - Meteor

Learnt about the different date formats allowed in the formula tool with this one

destroyboot
8 - Asteroid

My solution :)

CatheyH
8 - Asteroid

Hmmmm. My regex needs some work I think 😁 Went quite a long way around the houses but got there in the end.

Spoiler
CatheyH_0-1663261032739.png

 


 

jchen141
6 - Meteoroid

Great challenge! I've learnt a lot solving this one.

AnyoneCanModel
7 - Meteor

Parsing is fun!

Spoiler
DataBizViz_0-1663340929474.png

 

mg46
8 - Asteroid

Wow, this one was tough.  It's clunky and I went around my elbow to get to my thumb, but I did get there in the end!

Spoiler
mguarniere_0-1663352753477.png

 

amjadmanasra
8 - Asteroid

many ways to do this, this is my way , I liked the formal solution way as well 

KathrynMW
8 - Asteroid

Desperately tried to sort all dates out in the formula tool but gave up and did the ones I struggled with using the DateTime tool and then put the formula tool after those.  May not be pretty but it works.  

Spoiler
Challenge 4 Spoiler.JPG

nkinsey
8 - Asteroid
Spoiler
nkinsey_0-1664059161459.png

 

JoshuaB
Alteryx
Alteryx

Updated for my new handle

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter