We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# Weekly Challenges

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 #58: An Odd String to Date Conversion

8 - Asteroid

Same as challenge 46, but I tried a one-tool solution this time.

Spoiler

10 - Fireball

I need to be doing these, so here I go. Let's roll.

8 - Asteroid
Spoiler
8 - Asteroid

My solution below - same as Challenge 46 so decided to do it as a single Formula tool version this time

Spoiler
Formula: DateTimeParse(IIF(Left([date], 1) = "1", "20", "19") + Right([date], Length([date]) - 1), "%Y%m%d")

8 - Asteroid
Spoiler

8 - Asteroid

attached

7 - Meteor
Spoiler

8 - Asteroid

My solution

7 - Meteor
Spoiler

8 - Asteroid