Challenge #46: Formatting a Date from an Integer

[jarrod]

went with a conditional and regex on this one

Spoiler

iif(left([date],1)='1','20','19')+REGEX_Replace(Date,'\d(\d{2})(\d{2})(\d{2})','$1-$2-$3')

[Guillaume_G]

Here you go !!

[Arun_KV]

Here we go...  Thanks !!

[xinyoo]

nice and simple

[Rohit_G13]

A very common requirement with multiple ways to get to the solution

Thanks

Rohit Govind 

[jcollake]

I tried not to over complicate things here...went with regex which seems to be the unpopular route on this one.

Spoiler

[wincenzo]

Spoiler

Two possible solutions

[Nicholas_Norton]

Solution and spoiler attached 🙂

Spoiler

I tried to use the TrimLeft function at first to remove the number, but it accidentally removed too many! I had to use the Right function instead, since all the data has the same amount of characters. I also noticed that I could have saved a step and done the DateTimeParse function within the If statement, but it made more sense for me to split them into two separate columns. Overall, it was a nice and easy challenge that took me around 20 minutes to complete. 

[cmv]

This one was pretty easy!

Spoiler

ToDate(ToString(ToNumber(Left([date],1))+19)+Substring([date],1,2)+"-"+Substring([date],3,2)+"-"+Right([date],2))

[StellaBon]

Thanks!