# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #46: Formatting a Date from an Integer

Highlighted
6 - Meteoroid

Good challenge

Highlighted
7 - Meteor
Spoiler

Highlighted
6 - Meteoroid

Completed

Highlighted
7 - Meteor
Spoiler

My solution

Highlighted
6 - Meteoroid

Here is my solution

Highlighted
7 - Meteor

.

Highlighted
Alteryx

My take on this challenge:

Spoiler
iif(Left([date], 1)='1','20'+Right([date],6),'19'+Right([date],6))
Highlighted
8 - Asteroid

solution attached

Highlighted
8 - Asteroid

My solution.

Highlighted
8 - Asteroid

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.