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

sahinakos
8 - Asteroid
 
sahinakos
8 - Asteroid
 
kelsey_kincaid
12 - Quasar
Spoiler
Challenge21-KA.PNG
DataG8
8 - Asteroid

Thanks for some of the aforementioned IF statements, I would have gone with the join list.

Spoiler
Spoiler.PNG
mcultrera
8 - Asteroid

Didn't want to list out a 12 line text input or in a formula tool like the solution.  Instead I relied on the order of the input to drive to a month number which I converted to a date and then parsed out the month name.

willdupre
7 - Meteor

My effort for this one.

Kale_Malcom
8 - Asteroid
Spoiler
I don't love this solution with so many nested 'IF' statements, but I can't think of anything cleaner with the given data.wk_21_Snapshot.PNG
Etienne
8 - Asteroid

Solution attached

ascepkova002
8 - Asteroid

This was an interesting challenge.

My solution posted below

AndrewBanh
9 - Comet

Solution attached.