Measure intervals between records 1

[rwortman]

I am trying to construct a mean time between failures report from a work order based maintenance database. This requires me to report the time interval between the selected records. I know i can do this easily if I export the records to Excel. Any ideas how to do this within CR?

 

[dgillz]

Ken Hamady has this on his website:

http://www.kenhamady.com/form13.html

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[rwortman]

This formula counts the time interval between two different database fields. What I need to do is calculate to time interval between indentical fields in successive records

 

[BFAGG]

try a formula such as:

{datetimefield} - Previous{datetimefield)

Hope this helps

Bill Fagg

 

[rwortman]

Thanks.