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

Slacker
8 - Asteroid

How is this different than Challenge #46?  I copied my formula tool from 46 and it worked and I received the correct output.  Let me know if I am not seeing something here.

Milanz
9 - Comet

my solution 😉

Spoiler
Milanz_0-1612183195454.png

 

Eilean_
8 - Asteroid

RT

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1613153261173.png

 

binu_acs
21 - Polaris
Spoiler
binuacs_0-1613170289437.png

 

vikb123
8 - Asteroid

Solution below, similar to challenge #46 but good practice 🙂

vikb03_0-1613681942389.png

 

Spoiler
 
thaodinh95
8 - Asteroid

This is an easy one!

MohithRai
8 - Asteroid

Done!!!🚀

 

Spoiler
MohithRai_0-1613730378762.png

 

 

TheOC
16 - Nebula
16 - Nebula

One for me to revisit!

I had hoped to get it all within one Formula tool, however outputting a column requires dropping it in a select afterwards. 
I have an idea of how to implement this as one large if statement however!

Spoiler
TheOC_0-1613781484544.png

 

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
EmmyCC
7 - Meteor

solution attached.