Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

jridleh
7 - Meteor

Ended up having to use a text input. From looking at other solutions afterwards, I would most likely create a static table that would link the records to the month by record ID. Challenging though!

 

Spoiler
SPOILERChallenge21.PNG
SamDesk
11 - Bolide
Spoiler
Annotation 2019-10-08 144628.png

Sam

njsteengaard
6 - Meteoroid

Hereby my solution

kmalone007
8 - Asteroid

Solution

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_21_RODO_Solution.png
Parul_Kapoor
8 - Asteroid

Sol attached.

TomProwse
8 - Asteroid
 
mat_budden
8 - Asteroid

Hi 

 

Please see my Answer Below.

 

Spoiler
Used a Multirow Formula to spread the year, Then Tile to get the month number, then some date formatting... Probably not the best solution, But hey it works.

 

Thanks.

Mat

DuncanT
Alteryx Alumni (Retired)

Here's my solution.

sgrabish1
8 - Asteroid

Easy to do with guide alongside; thanks for practice