Challenge #46: Formatting a Date from an Integer

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[sumanthskumar]

Number 11

Spoiler

[Emil_Kos]

Hi,

Sharing my solution.

Very simple but interesting challenge. 

Spoiler

[DMContente]

here's my solution

[edavilac]

My solution attached.

Spoiler

[deviseetharaman]

Spoiler

[izamryan]

RegEx! It's your friend!

Spoiler

For this one I used a Formula tool with a bunch of formula in series:

[Year]
IF Left([date],1) = "1" THEN 20
ELSE 19
ENDIF

[date2]
Right([date],6)

[date_result]
[Year]+[date2]

I then used a RegEx to slice out the yyyy,mm,dd:
(\d{4})(\d{2})(\d{2})

and then another Formula tool to rehypothecate (!!!) the string
[yyyy]+"-"+[mm]+"-"+[dd]

and finally a Select tool to tidy up.

[mulvihi11]

DateTime tool remains a favorite of mine!

Spoiler

[mhou]

🙂