Challenge #46: Formatting a Date from an Integer

[johnemery]

Pretty straight forward here. Looking back, I could have made this slightly more efficient in terms of how many tools to use.

Spoiler

[sharathkumargurram1]

Hi ,

Solution has been uploaded.

Best Regards,

Sharath Kumar Gurram.

[rfergus]

Spoiler

[Verakso]

Just right after I have been fiddling with Python, the passing dates seemed to be easy.

Well at least I thought so until once more I saw @Joe_Mako' sweet solution.

Anyway, here is mine

Spoiler

The Workflow

The Result

My formula look like this:

DateTimeParse(IIF(Left([date], 1)=="1","20"+Right([date], 6),"19"+Right([date], 6)),"%Y%m%d")

Still Climbing

/Thomas

[manion72]

Thanks, this was a good little date conversion example.   I love it, every time I do these they get easier!   : )

[hanykowska]

My solution

[hmatthews92]

Solution attached

[Deevi]

PFA