Challenge #21: Date Reformatting

[SusieF]

Spoiler

[RobertMika]

Done

[JBarr]

Done!

[Oussaio]

My solution

Spoiler

[SAFG]

My solution is very similar to Oussaio's

Spoiler

However, I'm not that happy with the solution because:

Spoiler

Using the record ID to allocate a month makes an assumption that every month will be present in the data and in order, however if the data read J07, F, M, M skipping out April, then this method wouldn't work.. but I think the official solution is a bit laborious with regards to the formula.

Have there been any improvements on the official solution does anyone know ?

Cheers

[rosanguyen]

Spoiler

[cyg3003]

this is my solution~

[BeautiFolData]

Simple workflow with long formula

[ZacharyRyanTIL]

A solution has been found

[gerda]

Spoiler

 

Here's the solution!