Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.