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