How to calculate duration between two date/time fields?

Hello, Joseph.

I would suggest you to do a diff between the two datetimes, and then use the "invert" method to check if there is positive difference between them.

You can get more information on these links:

PHP: DateTime::diff - Manual

http://php.net/manual/en/class.dateinterval.php

Here is an example:

$interval = $datetime1->diff($datetime2);
if ($interval->invert) { // returns true if difference is positive
     if ($interval->h > 0) {
          return $interval->h; // h is for 'hour'
     } 
}

Best regards,

Ramon

Joseph,

We have an existing feature request asking to make calculations between datetime fields more readable.  The description in the feature request contains an example formula.  I haven't fully tested it with your scenario but it may point you in the right direction.

Hope this helps!

Lori

Joseph,

We have an existing feature request asking to make calculations between datetime fields more readable.  The description in the feature request contains an example formula.  I haven't fully tested it with your scenario but it may point you in the right direction.

Hope this helps!

Lori

Thanks, Lori. That calculation is a beast, but I'll see what I can do. :-)

Hi Joseph,

Have you tried something like this, (where 86400 is the number of seconds in a day):

round(divide(subtract(number(timestamp($date_modified)), number(timestamp($date_entered))),86400),0)

Which gives you the number of days between 2 dates.  But of course the formula could be modified

in ways to produce the proper format you are looking for.

Bob Bers