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.