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