Challenge #21: Date Reformatting

[lkclooney]

The expression statement for month translation is simpler than the original posted solution. Below is my translation expression:

IF [Month] = "J" AND [Row+1:Month] = "F" THEN "Jan"
ELSEIF [Month] = "F" THEN "Feb"
ELSEIF [Month] = "M" AND [Row+1:Month] = "A" THEN "Mar"
ELSEIF [Month] = "A" THEN "Apr"
ELSEIF [Month] = "M" THEN "May"
ELSEIF [Month] = "J" AND [Row+1:Month] = "J" THEN "Jun"
ELSEIF [Month] = "J" THEN "Jul"
ELSEIF [Month] = "A" THEN "Aug"
ELSEIF [Month] = "S" THEN "Sep"
ELSEIF [Month] = "N" THEN "Nov"
ELSE "Dec"
ENDIF

[mot]

Solution attached.

[Luke_C]

Spoiler

 

[vPir]

This is my contribution

Vagner

[jdbartosh]

Solution uploaded

[jpb5698]

Created a combination of things I read in the solution. I really disliked writing out the first multi-row formula, but I saw it was the cleanest way to redefine the months without relying on the position of the months with the same letters. I got a little lazy typing, so I needed to use a data cleanse tool to create consistency across my months, which I primarily did to test my knowledge of the tool. 

Since I was only working with 2 years I created a text file and appended the dates with the full year onto the current format. This was a cool challenge that forced me to use tools and formulas I haven't worked with too much yet. 

[jeremyhaber814]

Spoiler

[Daniel_Griffith]

Done!

[Gopi_Krishna_Bandi]

Hi, PFA my solution

[Gopi_Krishna_Bandi]

Hi Nicole,

I tried this way without using Tile.