Challenge #46: Formatting a Date from an Integer

[moakano]

Good challenge

[MarielJinang14]

Spoiler

[lkaushik]

Completed

[ALexAn]

Spoiler

 

My solution

[KRISHAR7AL]

Here is my solution 

[vinodkumar_mandora]

.

[KilianL]

My take on this challenge:

Spoiler

iif(Left([date], 1)='1','20'+Right([date],6),'19'+Right([date],6))

[Vikash_kumar]

solution attached

[Sylvana]

My solution.

[kennetheng]

I did things a little differently. I used three formula tools: 

1. Extract the LEFT number

2. Change that extraction to either 19 or 20 depending on if it was a 1 or a 0. 

3. Combine the new extraction with the RIGHT 6 characters from the original column. 

Then I used the Date/Time tool to format.