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

PhilBalderson
8 - Asteroid

I'm sure there's a more elegant way to do this ...

AlexCox
8 - Asteroid

My solution

KMiller
8 - Asteroid

Solution attached.

JoeS
Alteryx
Alteryx

Mod function to the rescue, I thought I was going mad for a little bit when the answers were not the same, then realised the times weren't either.....phew!

 

Spoiler
Workflow.png
allanq2001
6 - Meteoroid

Time_Now in the solution is different from the Time_Now of the start file. Anyway, my solution is matching based on my start time_now.

KevinW
8 - Asteroid
Spoiler
10.JPG
Paul-Evans
9 - Comet

Solved it two ways because I couldn't figure out why my first solution didn't match the provided output.

otresca
7 - Meteor

Solution added.

 

It'd be worth updating the input file so it matches the output.

 

sann0638
8 - Asteroid

a few formulas, will have a look to see if there's a quicker way!

JamesMA
Alteryx Alumni (Retired)