Challenge #46: Formatting a Date from an Integer

[bjkay30]

Here's my solution - similar to what many people had.

Spoiler

[Sihlex1]

 

[danicahui]

Spoiler

[JamesCameron]

My Effort. Not many moving parts!

Spoiler

[Kakuffo]

Im sure i could of done this easier but hey

[aihnen]

Solution attached.

Spoiler

[sonyakasenkramer]

I did it with ONE formula tool 🙂

Spoiler

ToDate(If left([Date],1) = '1' Then '20' + Left(Right([Date],6),2)
ElseIf left([Date],1) = '0' Then '19' + Left(Right([Date],6),2)
Else "Error" EndIf+'-'+Left(Right([Date],4),2)+'-'+Right([date],2))

[ozdogand]

here you go..

Spoiler

[JWS]

First time to use the function: ReplaceFirst(Str, Target, Replacement): Alway great to add another one to the collection