Challenge #21: Date Reformatting

[gcarroll]

Solution attached. Thanks!

[KevinW]

Spoiler

[TharunReddy]

Filter and two Multi-Row Formula Tools

Happy Practice :)

[rfergus]

Much simpler formulas than the official solution

Spoiler

[WH]

Spoiler

Instead of a long conditional formula, find and replace is used here.

[AdamBiggs]

A little different from other but same result :-) 

[Verakso]

Not that easy as I thought, but then I got to practice some use of the Multi-Row Formula tool

Spoiler

Challenge #21

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

Spoiler

I could see that in the solution, the Multi-Row Formula tool was used to write this formula

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' 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

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:

DateTimeFormat(DateTimeParse(ToString([RowID]),'%m'),'%b')

I'll guess which version one prefer, depends on how happy you are on typing 😀

Still climbing
/Thomas

[sharathkumargurram1]

Hi ,

Solution been posted.

Best Regards,

Sharath Kumar Gurram.

[CobusVenter]

Done

[manion72]

Glad to have worked on this one, I finally understand there are definitely two applications for the functions IsNull and IsEmpty...  : )   Thanks-!