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

stellarstevey
7 - Meteor
Spoiler
I don't love creating the month abbreviation based on values from another row, but I couldn't see an alternative.
bjschwartz3
8 - Asteroid

See attached solution.

ijkiv
6 - Meteoroid

My solution is similar to those of the others. I first get the year for each record. After this I use a text input tool and join based on Month and RecordID/ number of the month. 

Than_Alien
8 - Asteroid

Here you are!

vikb03
8 - Asteroid

Interesting challenge. Made a beast of a calculation to sort out the dates!

Spoiler
vikb03_0-1605291395455.png

 

vikb03_1-1605291430252.png

 

ShannonEWhite
6 - Meteoroid

Challenge 21 complete

michael_leoni
8 - Asteroid
Spoiler
Please see solution below. 
kmedici
8 - Asteroid
Spoiler
kmedici_0-1605692504721.png

 

smoskowitz
12 - Quasar

I seem to be in line with many of you fine people.

 

Thanks,

Seth

joshbennett
11 - Bolide
11 - Bolide

Here is my solution!