In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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 #21: Date Reformatting

NichWhit
6 - Meteoroid

Solution: 

 

NichWhit_0-1596224891859.png

 

ZLavasque
6 - Meteoroid
Spoiler
ZLavasque_0-1596225038273.png

 

DemandEngineer
8 - Asteroid

Sometimes without context it hard to know what solutions will work... I made the assumption that all months will be present (as the solution also need to look at adjacent rows)... and made an alternate solution.

bmcclelland46
10 - Fireball

My solution.

 

Spoiler

bmcclelland46_0-1596640685788.png

 

mollymargolis
8 - Asteroid

my solution

AnaisComyn
9 - Comet

Done ! 

ChrisBailey
7 - Meteor

Completed

nelsoer
6 - Meteoroid

solved using Formula Tool string manipulation and multi-row formula tool then joining on a month mapping table

verathut
7 - Meteor

Date with IF statement reformatting are definitely a bit challenging for me.

Leeia_I
9 - Comet
Spoiler
Annotation 2020-08-08 233219.jpg