Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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.

SUBMIT YOUR IDEA

Challenge #58: An Odd String to Date Conversion

ebostwick
8 - Asteroid

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

Spoiler
challenge_58_solution_EDB.jpg

chriswilliams41
11 - Bolide
11 - Bolide

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

RasmusFormo
8 - Asteroid
Spoiler
58.png
Rob-Silk
8 - Asteroid

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

 

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

 

logdog0411
9 - Comet
Spoiler
Screenshot 2023-12-07 111857.png

jennifer_owens
8 - Asteroid

attached

SanjeevDosanjh
7 - Meteor
Spoiler
Screenshot 2024-01-10 162142.png

snbandi
8 - Asteroid

My solution

SidSaythongphet
8 - Asteroid
Spoiler
Challenge 58 Solution.jpg

alfredcsy
8 - Asteroid

image.png