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

KirstyHarvey
8 - Asteroid

Not glamourous, but works just fine!

Ross_Easton
8 - Asteroid

Solved

 

Spoiler
21.PNG

FlorianC
Alteryx
Alteryx

This solution involves additional steps, but it is made entirely dynamic leveraging the built-in date-time functions.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1594221979288.png

 

jfeldkamp123
8 - Asteroid

Used record ID and modulo function to get remainders and number the months 1-12. Seemed easier than doing multi row formula to rename the months..... plus I like the modulo function - seems under utilized imo

mollyhatch
8 - Asteroid
Spoiler
21 Picture.PNG

 

LittleE
8 - Asteroid

This is a terrible solution; I will look at the official solution to see how to do this more cleanly.

Spoiler
LittleE_0-1594609955287.png

 

troyeb4
8 - Asteroid

Definitely getting my practice with Multi-Row formulas!

Spoiler

troyeb4_0-1594832412388.png

 

Imkep
6 - Meteoroid
Spoiler
Challenge 21.PNG
Samanthaj_hughes
ACE Emeritus
ACE Emeritus

Another oldie, I should have uploaded years ago, I hope to better these one day! 🙂

#Alteryxrocks