In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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 #10: Date Time Calculations

Tony_Castillo
10 - Fireball
Spoiler
Tony_Castillo_0-1631913708052.png

 

MichelleL
Alteryx
Alteryx

Thanks!

brandowd
8 - Asteroid

please find attached my solution which was similar to the one provided. I used the same formula against the 'output' provided to check as the 'Time_Now' were slightly different to the 'input' one.

 

Spoiler
brandowd_0-1632297242871.png

 

pfaigmani
7 - Meteor

My solution to challenge #10

BenFr
Alteryx Alumni (Retired)

Was catching me out until I saw the 41 seconds issue!

manisha0506
6 - Meteoroid

Here's my take on the solution

galmahalal
7 - Meteor

Solution for this challenge.

 

Thanks for that 🙂 

Anmol97
8 - Asteroid

Here's my solution

AlexBough
7 - Meteor

Solution in one tool! 😀

TheOC
16 - Nebula
16 - Nebula

Results slightly different but it sounds like thats normal:

Spoiler
TheOC_0-1633706771754.png




I ended up doing it with a lot of tools, and ended coming back to the formula tool. Looking at a couple other methods - i didn't use the mod function, may have to come back and have a look at this.

Cheers,
TheOC
Connect with me:
LinkedIn Bulien