Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
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

8 - Asteroid

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 🙂