Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANot that easy as I thought, but then I got to practice some use of the Multi-Row Formula tool
After I post this, I will head of and see in the solution how far I was off, even though I got the right answer...
EDIT:
Okay, so I tool a peek at the provided solution, but for once I liked my own better
IF [Month]=='J' AND [Row+1:Month]=='F' THEN 'Jan'But instead of writing all this, I used the Multi-Row Formula tool to generate a RowID for each month/year, and then I used the regular Formula tool to parse that as the month like this:
ELSEIF [Month]=='F' THEN 'Feb'
ELSEIF [Month]=='M' AND [Row+1:Month]=='A' THEN 'Mar'
ELSEIF [Month]=='A' AND [Row+1:Month]=='M' THEN 'Apr'
ELSEIF [Month]=='M' THEN 'May'
ELSEIF [Month]=='J' AND [Row+1:Month]=='J' THEN 'Jun'
ELSEIF [Month]=='J' AND [Row+1:Month]=='A' THEN 'Jul'
ELSEIF [Month]=='A' AND [Row+1:Month]=='S' THEN 'Aug'
ELSEIF [Month]=='S' THEN 'Sep'
ELSEIF [Month]=='O' THEN 'Oct'
ELSEIF [Month]=='N' THEN 'Nov'
ELSEIF [Month]=='D' THEN 'Dec'
ELSE ''
ENDIF
DateTimeFormat(DateTimeParse(ToString([RowID]),'%m'),'%b')I'll guess which version one prefer, depends on how happy you are on typing 😀
Still climbing
/Thomas