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

NichWhit
6 - Meteoroid

Solution: 

 

NichWhit_0-1596224891859.png

 

ZLavasque
6 - Meteoroid
Spoiler
ZLavasque_0-1596225038273.png

 

DemandEngineer
8 - Asteroid

Sometimes without context it hard to know what solutions will work... I made the assumption that all months will be present (as the solution also need to look at adjacent rows)... and made an alternate solution.

bmcclelland46
10 - Fireball

My solution.

 

Spoiler

bmcclelland46_0-1596640685788.png

 

mollymargolis
8 - Asteroid

my solution

AnaisComyn
9 - Comet

Done ! 

ChrisBailey
7 - Meteor

Completed

nelsoer
6 - Meteoroid

solved using Formula Tool string manipulation and multi-row formula tool then joining on a month mapping table

verathut
7 - Meteor

Date with IF statement reformatting are definitely a bit challenging for me.

Leeia_I
9 - Comet
Spoiler
Annotation 2020-08-08 233219.jpg