We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #10: Date Time Calculations

lkim524
8 - Asteroid

wish the datetimediff formulas were a little easier to work with...

CMWalsh
8 - Asteroid
Spoiler
CMWalsh_0-1660921273075.png

 

ahsanaali
8 - Asteroid
Spoiler
Spoiler
ahsanaali_0-1661106171295.png

 

Thomas_Wells_2dot0
8 - Asteroid

I was today years old when I learned about the Modulo operation :) 

 

Spoiler
Solution.jpg
Pete_Rodgers
Alteryx
Alteryx

 

Spoiler
Pete_Rodgers_0-1661248629057.png

 

Pete Rodgers
Solutions Engineer | UK&I Public Sector | Alteryx
harrietowen30
7 - Meteor
Spoiler
harrietowen30_0-1661258748982.png

 

FinnCharlton
8 - Asteroid
Spoiler
FinnCharlton_0-1661519259698.png

 

Took me far too long to realize the times are different in the output file...

Muhammadmaaz
7 - Meteor

my solution

grazitti_sapna
17 - Castor

grazitti_sapna_0-1662092960344.png

 

Sapna Gupta
geoff_zath
Alteryx
Alteryx

 

Spoiler

geoff_zath_0-1662487340033.png