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

franko003
6 - Meteoroid

 

My solution.  Looks to be a bit more complex than what was posted.

 

Spoiler
alteryx_weekly_challenge_solution.PNG
HuwHallam
8 - Asteroid

My solution - nice bit of date conversion practice!

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Abell
7 - Meteor

Took a slightly simiiar approach to @SeanAdams, however it feels pretty inefficient the way I did it.

rachelgatto
8 - Asteroid

Solved. 

Parul_Kapoor
8 - Asteroid

Here is the solution

abinder
6 - Meteoroid

solution attached

Brian6
8 - Asteroid
 
Shifty
12 - Quasar

Solution and steps in the spoiler.

 

 

Spoiler
Text to columns, select to rename, multi-row formula twice (1) to add a zero and fill down and (2) to convert letters to months.
Challenge 21 Flow.jpg
Also: Iron Man dies in Endgame.  You were warned there were spoilers!
nickjastrzebski
8 - Asteroid

Much more difficult than I was expecting. My current solution isn't very dynamic but I'm thinking adding some RegEx to extracting the year may help improve this.

 

Spoiler
image.png