Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

LandonG
8 - Asteroid

Solution.

PhilipMannering
16 - Nebula
16 - Nebula

Note to self: create date parsing cheat sheet.

 

I wanted to avoid having to brute force it with a long calc and parse a number to get the month.

 

Solution attached.

 

Spoiler
challenge_21 - Snip.PNG
jasperlch
12 - Quasar

Solution attached.

SGolnik
11 - Bolide
11 - Bolide

I did it with a couple more tools instead of writing a lengthy formula.

BrendaS
8 - Asteroid

My solution!

aclaxton
8 - Asteroid

Got it done in two :D

Spoiler
Week 21.png
michalsicak
7 - Meteor

I tried to avoid typing in month names, but could not find a quick way.

 

Spoiler
challenge21.png
derekbelyea
12 - Quasar
Spoiler
ch21.png
blairmbailey
8 - Asteroid

Solution attached - thanks!

MaxGiegerich
8 - Asteroid

More tools but more succinct I think, and less typing!