Challenge #46: Formatting a Date from an Integer

[jrobiso2]

I think the biggest difference between the given solution and the one-liner DateTimeParse(Switch(Left([date],1),'','0','19','1','20')+Right([date],6),'%Y%m%d') is in readability.  It's going to take some effort to parse my way through DateTimeParse(Switch(Left([date],1),'','0','19','1','20')+Right([date],6),'%Y%m%d') and figure out what the heck it is doing, even if it is more "efficient".

[dbAlfa]

Below, my solution.

[Brian32]

Challenge Solution:

Spoiler

[KalpanaM]

[CMWalsh]

Spoiler

[Abiramm1]

simple challenge with a pretty simple solution (normally I overcomplicate everything) :)

Spoiler

[mbcoar]

Challenge 46 Complete

[AndrewHoData]

Feels good to get this done!

Spoiler

 

[lkim524]

lot of formula string edits.

[umeshsiyak]

Did with Formula