ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

smoskowitz
12 - Quasar

Loved it!

Parul_Kapoor
8 - Asteroid

Here is the solution attached.

JORGE4900
8 - Asteroid

There was a very similar challenge like this one. This time I added a character length validation to ensure the field contains 7 characters, otherwise return a null date.

 

Spoiler
2019-05-16_14-02-07.jpg
Thableaus
17 - Castor
17 - Castor

Challenge #58, done.

 

Spoiler

 

Challenge_58.PNG

 

 

Cheers,

msicak
8 - Asteroid

in the interest of clarity i used more tools:

 

Spoiler
ch58_msicak.png
erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

bkclaw113
10 - Fireball
 
gmartin
7 - Meteor

Here is my solution:

 

Spoiler
challenge_58_gm_image.PNG
Gopinaath
8 - Asteroid
Spoiler
My Solution: I have 2 alternate paths to the date conversion. One using a datetime parse tool and the other one using a formula tool.

 

cgoodman
ACE Emeritus
ACE Emeritus

Given I did the longer route this this earlier today, here's the one tool solution (2 if you could the expect equals tool!).

 

Spoiler
challenge 58.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com