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.
alteryx Community

# 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

17 - Castor

Hi @Kirstyp,

If you have converted your two date fields to actual datetime format using the date parse tool, you can build a formula using datetimediff(datetimeA,datetimeB,"minutes") which will give you the difference between the two regardless of whether it goes over to the next day.

8 - Asteroid

Great, thanks very much for your help.

16 - Nebula

Solution attached.

Spoiler
7 - Meteor

Attached solution with one formula field(3 formulae)

14 - Magnetar

Here's my solution.

Spoiler
9 - Comet

Spoiler
Used MOD function as well

8 - Asteroid

Close but no cigar for me. Didn't know about the modulo function so used Floor instead, which got me close but not 100%.

ACE Emeritus

This one was good, never had a usecase for the MOD function before so was handy to get some practice with this.

Spoiler
17 - Castor
Spoiler
Just used a bunch of datetimediff functions and subtracted the parts.
8 - Asteroid

I find the solution provided here quite confusing and requires a great deal of unpicking. Mine I find intuitive (but then I would I suppose...). For each subdivision:

• Add the previous subdivision(s) to the timestamp
• Take a datetimediff between the TIMESTAMP and the new Time_Now.

Done.