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

mihir_sampat
7 - Meteor

Fairly easy challenge. I solved the problem using the Formula Tool and the DateTimeDiff Function. Not much to talk about the solution.

Spoiler
Challenge 10 solution.PNG

 

JoePC
9 - Comet
Spoiler
JoePC_0-1595504554518.png

 

Screenshot of solution attached as was getting an error when uploading.

dmhatchell
7 - Meteor
Spoiler
dmhatchell_0-1595687991636.png

 

DemandEngineer
8 - Asteroid

If possible please update the Start and Solution files so the Date time columns match between the 2 files.

Per
11 - Bolide

Went with the FLOOR function.

 

Thanks @MarqueeCrew. Always end up googling this post when I can´t remember the name of the function 🙂

CR_Marland
8 - Asteroid
Spoiler
solution 10.PNG
wwatson
12 - Quasar

my solution. The input data for the input and solution are different so I used both for comparison

alynnreau
8 - Asteroid

Challenge 10 

kevin025
8 - Asteroid

Here is my solution

 

Challenge#10.png

mollymargolis
8 - Asteroid

My solution for this challenge