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