Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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

Tisaac95
8 - Asteroid
Spoiler
 
JonathanW
8 - Asteroid

My solution is just a formula tool so I won't post screenshot

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_1-1578369108444.png Original_Yodies_2-1578369156394.png

 good date formulas challenge.

andypick
8 - Asteroid

solution attached

 

Spoiler
Capture.PNG
mdodrajka
8 - Asteroid

Very interesting requirement.

 

Spoiler
Initially solved it with just using Nested DateTimeDiff. Then got inspired by the Floor function used by Sean so did it the arithmetic way.

Challenge_10_Mdodrajka.PNG

ShawnTM
8 - Asteroid

Hi, here's my solution. My values for seconds differ slightly from the example output, but i think it's due to the fact that the inputs also differ slightly.

Spoiler
ShawnTM_0-1578678278778.png
jad0575
6 - Meteoroid
Spoiler
I did it with a lot of equations because I forget about the MOD. good one.
terry10
12 - Quasar

 

 

dashakir1
8 - Asteroid

Thanks GeneR.

justinjohnson02
7 - Meteor
Spoiler
justinjohnson02_0-1579404470568.png