Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #21: Date Reformatting

8 - Asteroid

Not glamourous, but works just fine!

Highlighted
7 - Meteor

Solved

 

Spoiler
21.PNG

Highlighted
Alteryx
Alteryx

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

 

Spoiler
WorkflowWorkflow
Florian Carrier
Solutions Engineer
Alteryx
Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1594221979288.png

 

Highlighted
7 - Meteor

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

Highlighted
Alteryx Partner
Spoiler
21 Picture.PNG

 

Highlighted
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

 

Highlighted
Alteryx Partner

Definitely getting my practice with Multi-Row formulas!

Spoiler

troyeb4_0-1594832412388.png

 

Highlighted
6 - Meteoroid
Spoiler
Challenge 21.PNG
Highlighted
11 - Bolide
11 - Bolide

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

#Alteryxrocks