In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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 #414: Mastering Date Formats

plozbin
8 - Asteroid

My solution. Fun challenge! First time in a long time using the DateTime tool.

 

Spoiler
 
Alteryx Challenge 414 Solution.png

 

Dev73
8 - Asteroid

here is my take- 🤗

Spoiler
challange 414.png
TobiasFitschen
8 - Asteroid
Spoiler
Challenge_414.png

Did not manage to make an uglier workflow, but at least the result is alright :)

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my workflow ! Single formula + sort !

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2024-03-05 181426.png
aatalai
14 - Magnetar

2 tools (could of don it in one, but would have made the if statement more complicated

ggruccio
ACE Emeritus
ACE Emeritus

I tried first to see if the tool could handle multiple date formats.

 

Spoiler
414.png
Ray_Pospisil
8 - Asteroid

Alteryx, SQL, pandas and pyspark solutions

lukas_olsovsky
8 - Asteroid

Nice challenge, thanks!

 

Running time 0,2sec

Spoiler
Spoiler
 

414 solution.jpg

 

erike601
7 - Meteor
Spoiler
alteryxchallenge414.jpg