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!

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
8 - Asteroid

my solution 😉

Spoiler
Milanz_0-1612183195454.png

 

Eilean_
8 - Asteroid

RT

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1613153261173.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1613170289437.png

 

vikb03
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
15 - Aurora
15 - Aurora

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

 


Bulien
EmmyCC
7 - Meteor

solution attached.