ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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

rapetter
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