alteryx Community

# 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.

## Challenge #10: Date Time Calculations

5 - Atom

My solution with only one Preparation.

6 - Meteoroid

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

17 - Castor

Solved!

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

Spoiler

Calvin Tang
Alteryx ACE
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!