Challenge #21: Date Reformatting

[Robinvm]

Solved

[jumansky]

Solution to Challenge 21

[jon_amanrich]

My solution for the week 21 challenge, I may have taken a long route 😅

Spoiler

Multirow to fill in the year field. 
summarize: group by year, count year
generate row to get month number
formula: month+'/'+year
convert datetime: string to date
convert datetime: date to string in format 'Monyy'
add record Id on original dataset and output and join on recordID

[DSinnett]

Used DateTimeFormat and DateTimeParse to get the required Month output.

[Watermark]

Spoiler

 

[jestinejoseph]

IF [RegExOut1] IN ("F","S","O","N","D") THEN Switch([RegExOut1],Null(),"F","Feb","S","Sep","O","Oct","N","Nov","D","Dec")

ELSEIF [RegExOut1] = "J" AND [Row+1:RegExOut1] = "F" THEN "Jan"

ELSEIF [RegExOut1] = "J" AND [Row-1:RegExOut1] = "M" THEN "Jun"

ELSEIF [RegExOut1] = "J" AND [Row-1:RegExOut1]= "J" THEN "Jul"

ELSEIF [RegExOut1] = "M" AND [Row-1:RegExOut1]= "F" THEN "Mar"

ELSEIF [RegExOut1] = "M" AND [Row-1:RegExOut1]= "A" THEN "May"

ELSEIF [RegExOut1] = "A" AND [Row-1:RegExOut1]= "M" THEN "Apr"

ELSEIF [RegExOut1] = "A" AND [Row-1:RegExOut1]= "J" THEN "Aug"

ELSE Null()
ENDIF

[Tubalady]

Here is my solution.  There has to be a better way to convert a Month # to a Month Name...

[benjamin_feuchter]

Spoiler

[dYoast]

This took a little thinking.

Spoiler

[r_manju02]

Here is my solution