Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

etechman
8 - Asteroid

For some reason this one really threw me for a loop.  Nonetheless I still got a solution finally.

LukasJennings
8 - Asteroid
Spoiler
Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days') Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24)  Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') -                 (DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60) Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') -                  (DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days') Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24) Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') - (DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60) Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') - (DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)

 

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([Days]*24)
Minutes = DateTimeDiff([Time_Now],[TIMESTAMP],'minutes') -
(DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60)
Seconds = DateTimeDiff([Time_Now],[TIMESTAMP],'seconds') -
(DateTimeDiff([Time_Now],[TIMESTAMP],'minutes')*60)

Sashikumar
8 - Asteroid

Nice.

Spoiler
ch10.PNGch10_1.PNG
Blair_A
7 - Meteor

Here's my solution for this challenge. I did update the task input data to be the same as the output data.

Spoiler
Challenge 10.jpg
navneetmohit
6 - Meteoroid

This is the shortest method I could think of. Will appreciate if someone could comment on this to tell me if I was right or wrong.

greggrimmer1
8 - Asteroid
Spoiler
greggrimmer_0-1603293711093.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-22 à 15.13.38.png
WernerE
8 - Asteroid

Nice one, Thanks

Spoiler
Screenshot_1.jpg

 

michael_leoni
8 - Asteroid
Spoiler
Please see my solution below. 
MikeLR
8 - Asteroid

I went for separate formula tools for each step

Spoiler
MikeLR_0-1604936598992.png