Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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