We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

mceleavey
17 - Castor
17 - Castor

Hi @Kirstyp,

If you have converted your two date fields to actual datetime format using the date parse tool, you can build a formula using datetimediff(datetimeA,datetimeB,"minutes") which will give you the difference between the two regardless of whether it goes over to the next day.



Bulien

Kirstyp
8 - Asteroid

Great, thanks very much for your help.

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

Spoiler
WC10.png
dheerajpoojari
7 - Meteor

Attached solution with one formula field(3 formulae)

jamielaird
14 - Magnetar

Here's my solution.

 

Spoiler
Screen Shot 2017-08-27 at 14.31.47.png
Natasha
9 - Comet

 

Spoiler
Used MOD function as well

Screen Shot 2017-08-28 at 00.29.32.png

 

JacobR77
8 - Asteroid

Close but no cigar for me. Didn't know about the modulo function so used Floor instead, which got me close but not 100%.

BenMoss
ACE Emeritus
ACE Emeritus

This one was good, never had a usecase for the MOD function before so was handy to get some practice with this.

 

Spoiler
Capture.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
Just used a bunch of datetimediff functions and subtracted the parts.
Capture.PNG
MaxGiegerich
8 - Asteroid

I find the solution provided here quite confusing and requires a great deal of unpicking. Mine I find intuitive (but then I would I suppose...). For each subdivision:

  • Add the previous subdivision(s) to the timestamp
  • Take a datetimediff between the TIMESTAMP and the new Time_Now.

Done.