In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

lucaskro
8 - Asteroid
Spoiler
lucaskro_0-1684399768998.png

 

kaitlinDS37
8 - Asteroid
Spoiler
kaitlinDS37_0-1684399811226.png

 

katejoyce87
8 - Asteroid

:)

FMODACK
7 - Meteor

My solution.

SaraHamdoun
8 - Asteroid
Spoiler
Here's my solution:

Challenge 10.JPG
matthewblandford
8 - Asteroid

Use of the Mod function makes this a one-tool solution!

tothd
8 - Asteroid

ok

boglarkalipka
8 - Asteroid

solved

zorecchi
6 - Meteoroid

A couple of points from this exercise. I'm not sure why the DateTimeFormat function was used in the solution; both TimeDate columns provided are in formats recognized by Alteryx. I now understand the MOD function that was used in the solution (mod = "remainder"), but this doesn't seem like the most intuitive way of approaching this problem. I instead used the FLOOR function (similar to ROUNDDOWN in excel). I provided two solutions in the attached workflow; one similar to the provided solution and one using the Floor function instead.

nbilal
7 - Meteor

Here's my solution using a single formula tool with a bunch of DateTimeDiff function calls.