Challenge #21: Date Reformatting

[stellarstevey]

Spoiler

I don't love creating the month abbreviation based on values from another row, but I couldn't see an alternative.

[bjschwartz3]

See attached solution.

[ijkiv]

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]

Here you are!

[vikb123]

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

Spoiler

[ShannonEWhite]

Challenge 21 complete

[michael_leoni]

Spoiler

Please see solution below. 

[kmedici]

Spoiler

[smoskowitz]

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

Thanks,

Seth

[joshbennett]

Here is my solution!