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!