Challenge #46: Formatting a Date from an Integer

[amitsrivastava]

My solution for this challenge.

[RoDO]

My solution

Spoiler

FORMULA:
DateTimeParse(
IF Left([date], 1) = '1'
THEN '20' ELSE '19' ENDIF
+ Right([date], 6),
'%Y%m%d')

[sgrabish1]

Done!

[myouree]

My solution

[Hezabel]

I chose to sort out the year, then deal with the format in one go.  I like the single formula route - very slick!

[Christoph_Ebersbach]

Solved

[sarahjohnson]

Spoiler

[Hitch]

Here's my attempt

[apabonok]

This is my solution:

Evalute 1st digit and concatenate 19 or 20 (according to rule) to the rest of string. Then, parse to date.