Challenge #21: Date Reformatting

[Syfer889]

Liked the Parse and rename based on numeric values. Is there a need for the original Date to be included in the output. I was thinking of not including, but solution already had it...

[CHarrison]

Made use of MOD12 function & a fairly length formula in mine 

[asabau]

Here it is!

[JamesLawlor]

Spoiler Attached.

[deepsingh]

Hello,

Please find attached my solution.

Thanks!

[maxjohnson02]

Solution attached.

[kelly_gilbert]

Spoiler

I converted the month/year into a date and formatted using %b rather than using an if statement to return the month name (although the if statement is probably simpler!)

[OllieClarke]

I'm sure there's a better way than mine, but if it works...

[JordyMicheal]

Spoiler

IF
contains([DATE],"J") && [Row+1:DATE] == "F" THEN "Jan"
elseif [DATE] == "F" Then "Feb"
elseif [DATE] == "M" && [Row-1:DATE] == "F" THEN "Mar"
Elseif [DATE] == "A" && [Row-1:DATE] == "M" THEN "Apr"
Elseif [DATE] == "M" && [Row-1:DATE] == "A" THEN "May"
Elseif [DATE] == "J" && [Row-1:DATE] == "M" THEN "Jun"
Elseif [DATE] == "J" && [Row-1:DATE] == "J" THEN "Jul"
Elseif [DATE] == "A" && [Row-1:DATE] == "J" THEN "Aug"
Elseif [date] == "S" then "Sep"
Elseif [date] == "O" Then "Oct"
Elseif [date] == "N" Then "Nov"
Elseif [date] == "D" Then "Dec"
Else
[date]
endif

[tochy]