Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

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