Challenge #21: Date Reformatting

[DataKyle]

I always enjoy going through these challenges as they provide a chance to utilize tools that are less common for me to have a need for.

[rslopez2]

Used slightly different Tools but overall same approach as provided Solution 🙂

- Used Multi-Row Formula to get month Numbers based on date Length (loved solution provided nested formula to achieve this with simple the formula tool!)

- Used Formula to convert Int values to 3 letter Month 

- Used Multi-Field Formula to Populate current year based on if it was first month

- Used Multi-Row Field to Populate correct year across all Rows

- Select to Rename and drop unnecessary Fields 

Spoiler

[rcor]

Spoiler

[ocasey]

A bit different, same result

[MartinStraech]

Felt like this was one of my uglier solutions. I still need to get more proficient with the multi row formula tool.

Spoiler

[Marcel_Gavrila]

Here's my solution with only 2 tools 🙂

Spoiler

[bnelly1987]

Kind of ugly but it works

Spoiler