Challenge #21: Date Reformatting

[MMoore-2021]

As per usual, figured out a workable solution before consulting the solution provided.  Obviously need to spend some time with the multi-row tool and the building logical expressions.  Thanks for the challenge!

[kglearner]

Spoiler

Since data structure is in order (J to D) and no repetition between Month, I used RecordID and later Mod (RecordID, 12) so that I can create logics between modified RecordID (1-11,0) to month (Jan - Nov, Dec).

[MalluShroomer]

Done

[saeedsemrin]

solution

[JesterOne]

My Solution:

Spoiler

[v_lauto0001]

Another possible solution! 

[ENix]

Spoiler

[j_trefethen]

Challenge 21 - completed

[Erin]

Hello,

My submission is attached with two different ways of the same answer. 

Spoiler

If this was a situation where the final value is needed in more of a date format, then I think the first path with the Date Time tool should be explored further. However, the formula tool trying out a switch fx is a quicker solution. Somehow I was expecting to use more date formulas in this exercise and making it more complicated than it needed to be. 

[Thomas_W]

Solution attached