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

5 - Atom

My solution with only one Preparation.

5 - Atom

Challenge completed using DateTimeDiff tool

7 - Meteor

Solved this exercise.

have used formula tool to extract day, minutes, hours, seconds from two dates provided.

6 - Meteoroid

I feel like I'm playing games while I'm creating Alteryx workflows.

Solved! Solved! Solved!

Tools to get the solution are - Formula

Used Formulae are -

Days - DateTimeDiff([TIME_NOW],[TIMESTAMP], 'days')

Hours - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "hours"),24)

Minutes - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "minutes"),60)

Seconds - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "seconds"),60)

8 - Asteroid
Spoiler

8 - Asteroid

Solved!

Though cross-checking was one tough one. Thought I was doing something wrong for a solid 10 minutes.

Spoiler

7 - Meteor

my solution

7 - Meteor

7 - Meteor
Spoiler

8 - Asteroid

The two files being different really messed with my brain but we got there lol!