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

anshuverma0912
8 - Asteroid

Hi, Here is my solution!!

LukasJennings
8 - Asteroid
Spoiler
Weekly Challenge 21 Solved.jpg

 

xxreese
8 - Asteroid

I got it in perhaps a round about way

alexnajm
19 - Altair
19 - Altair

Done! A little bit of a different way...

simbert
8 - Asteroid

Slightly lengthy solution to avoid having to write a really long if statement

Spoiler
simbert_0-1601395293335.png

 

gokhane
7 - Meteor

the hard way...

LGFAnalyst
6 - Meteoroid

The second multi-row formula really stumped me, I was excited to find a use for the multi-row formula's "fill down", but had no idea how to do the month assignment. 

 

Thanks for the challenge!

DeanWest
9 - Comet

This was fun! I incorporated a simple use of the Tile Tool in my solution below:

 

Spoiler
challenge_21_Solution-DeanWest_snippet.PNG
DataNexus
7 - Meteor

Nothing special about my response.

OwenBData
8 - Asteroid

My solution!:

Spoiler
Challenge 21.PNG