Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

isundari
7 - Meteor

Need more sample for date and time.

Thanks for the guidance.

danbostrom
8 - Asteroid

 

 

DrewKoontz
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


KevinKeiser
7 - Meteor

Solution attached below

rebecca_petter
8 - Asteroid

Done

deanabilaresa
7 - Meteor

My solution for this challenge as attached file. 

 

Thank you

Supriya2203
8 - Asteroid

My solution

michael_apau
8 - Asteroid
Spoiler
Screenshot 2024-09-02 191541.png

manas_swaroop
7 - Meteor

Solution.

Shoujain
7 - Meteor

My Solution