It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

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

8 - Asteroid

Solution.

9 - Comet

Solution Attached

8 - Asteroid

Here is my solution

Formula used:

Spoiler
if StartsWith([date], "1")
then ReplaceFirst([date], "1", "20")
else ReplaceFirst([date], "0", "19")
endif

9 - Comet

Pretty simple one.

12 - Quasar

my solution

7 - Meteor

Solution for the  Challenge #46: Formatting a Date from an Integer

7 - Meteor

Here is my solution

7 - Meteor

Here is my solution for this problem. I used wayy too many formulas.

7 - Meteor

Completed

7 - Meteor

only one tool solution 🙂