Challenge #46: Formatting a Date from an Integer

[samahmed28]

Solved

[ChiN]

Pretty good exercise for date time practice ! 

[carmenrapariz]

Did it!

[PeterH23]

My solution.

Spoiler

[Preethi07]

I used left((if Substring([date],0,1)='0' then '19' else '20' endif)+ToString(Substring([date],1,length([date]))),4)+"-"+Substring([date],3,2)+"-"+Substring([date],5,2) to get the results.

But interested in understanding the efficiency of using Left/right vs. Substring;switch vs. if..else.

[Simha]

Here's one of the ways...

[kwilkins]

Attached is my solution using formula, date/time parse tool and select... the solution is much slicker. I've never used a datetimeparse tool before...I'll have to remember that.

Spoiler

SPOILER