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