ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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
Asteroid

Hi, Here is my solution!!

LukasJennings
Asteroid
Spoiler
Weekly Challenge 21 Solved.jpg

 

xxreese
Asteroid

I got it in perhaps a round about way

alexnajm
19 - Altair
19 - Altair

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

simbert
Asteroid

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

Spoiler
simbert_0-1601395293335.png

 

gokhane
Meteor

the hard way...

LGFAnalyst
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
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
Meteor

Nothing special about my response.

OwenBData
Asteroid

My solution!:

Spoiler
Challenge 21.PNG