Challenge #21: Date Reformatting

[A_Twa]

I used the Record ID and Formula tools to get my answer; the official solution never even occurred to me.  Great stuff, thank you!

[MsBindy]

Wow!  Some very creative solutions.  I enjoy exposure to new ideas.  Mine is pretty much the same as the solution.  I think I've seen something like this so already had a pre-determined paradigm in my head.

[Pablo0205]

Hi there, I'm pretty new to the Designer and formulas aren't my strenth yet, so I looked them but here's my workflow.

[nick_ceneviva]

Solution Attached

[jamielaird]

Here's my solution.  Can definitely be done with fewer tools but this is what I found quickest.

Spoiler

[luciebrett]

Slightly different order to the solution; started formatting the month first to utilise the placement of the year in Jan before dragged down (I think the expression used is more logical and easy to understand), but same tools used overall!

[patrick_digan]

Spoiler

[Natasha]

Used Regex and a combination of DateTimeParse / DateTimeFormat

Spoiler

[data_rachel]

Spoiler

That second multi-row formula has a really long (and tedious) formula.

[marcreid]

Solution

Spoiler

Took the month number conversion approach