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

7 - Meteor

Need more sample for date and time.

Thanks for the guidance.

8 - Asteroid

7 - Meteor

Solution using one Formula Tool

Spoiler
Day:
DateTimeDiff([TIMESTAMP],[Time_Now],"Days")*-1

Hours:
(DateTimeDiff([TIMESTAMP],[Time_Now],"Hours") + 24*[Days])*-1

Minutes:
(DateTimeDiff([TIMESTAMP],[Time_Now],"Minutes") + [Hours]*60 + [Days]*1440)*-1

Seconds:
(DateTimeDiff([TIMESTAMP],[Time_Now],"Seconds") + [Minutes]*60 + [Hours]*3600 + [Days]*86400)*-1

7 - Meteor

Solution attached below

8 - Asteroid

Done

7 - Meteor

My solution for this challenge as attached file.

Thank you

8 - Asteroid

My solution

8 - Asteroid
Spoiler

7 - Meteor

Solution.

7 - Meteor

My Solution