Challenge #46: Formatting a Date from an Integer

[Karam]

My solution ..

Spoiler

[EW]

I'm really glad a lot of these challenges are date format related, dates continue to vex me way more than they should!

My solution with one formula:

Spoiler

[ipeng]

I use a bunch LEFT() and RIGHT() functions. The posted solution is a quicker way

[ddiesel]

My solution:

Spoiler

[DavidThorpe]

My solution:

Spoiler

Originally used an IF statement to replace the 0 and 1 with the corresponding values and datetimeparse, instead learnt the SWITCH function which I hadn't used before and changed the formula

[RolandSchubert]

My solution

[AJauniskis]

Quite an easy one

Spoiler