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
アステロイド

Not glamourous, but works just fine!

Ross_Easton
アステロイド

Solved

 

スポイラ
21.PNG

FlorianC
Alteryx
Alteryx

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

 

スポイラ
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
balajilolla
アステロイド
スポイラ
Solution Attached

balajilolla_0-1594221979288.png

 

jfeldkamp123
アステロイド

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
アステロイド
スポイラ
21 Picture.PNG

 

LittleE
アステロイド

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

スポイラ
LittleE_0-1594609955287.png

 

troyeb4
アステロイド

Definitely getting my practice with Multi-Row formulas!

スポイラ

troyeb4_0-1594832412388.png

 

Imkep
メテオロイド
スポイラ
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