Difference between 2 Date Time fields

[Millstone]

Hi,

I need a report which shows response times to web requests - I have a datetime field for RequestedAt and another for ActionedOn.

Does anyone know how to take these 2 datetime fields, and produce a formula to give me the difference between them in Hours and Minutes???

Matt.

 

[FoxG]

Hi,

The following formula should work

local numbervar n := {date_time_1} - {date_time_2);
local numbervar h := Truncate(n / 3600);
n := Remainder(n,3600);
local numbervar m := Truncate(n / 60);
local numbervar s := Remainder(n,60);
totext(h,"00&quot+":"+totext(m,"00&quot+":"+totext(s,"00&quot

Hth,
Geoff

 

[FoxG]

Hi,

Correction to above ...

local numbervar n := {date_time_1} - {date_time_2);
n = n * 24 * 60 * 60

Need to do this to convert to seconds !

Geoff