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 #414: Mastering Date Formats

Erin
11 - Bolide

Pretty sure I did this in the most convoluted way possible, but at least it's dynamic. 

Spoiler
414pic.jpg
ydmuley
12 - Quasar
12 - Quasar
Spoiler
Challenge 414_Solution_Yug.png

I have solved a similar one before but used a simple technique last time, this time thought to go with Batch Macro.

 

mm to MM convertion was also a trik!

 

The solving thrill continues!!!!!!!!!!!!!!!!

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution:

ahsanaali
11 - Bolide
Spoiler
414.png

adamweaver39
9 - Comet

Love a good parse and date conversion practice!

Spoiler
challenge 414 - alteryx workflow.jpg
Amy_smart
11 - Bolide

Here is my solution.

davidhardister
8 - Asteroid

Used a macro to update the format for each row using the DateTime tool

Spoiler
Capture.PNG


Capture2.PNG

AGilbert
11 - Bolide
Spoiler
Screenshot 2024-05-08 130919.png
vicakram
7 - Meteor
Spoiler
My Solution Weekly Challenge- 414.png
Bobbyt23
13 - Pulsar

Probably a much cleverer solution using Regex or Formulas than mine, but went with what I know.