Get Days/Hours/Mins between DateTime1 and DateTime2 - Crystal 7.0 ???

[alistairpaul]

Hi folks - I've got 2 fields that have datetime values in the form of '05/09/01 16:31:03'. I need to calculate the amount of days, hours, and minutes between the two fields.

I've read Ken Hamady's stuff, but it references functions unavailable to me in CR 7.0, and I thought I saw a big function come through the forum a few weeks ago, but I was unable to find it.

Does anyone have a good formula that they could pass on?

Thanks!!

 

[kenhamady]

You can download all of the V8 functions for use in V7 from Seagate's webiste. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)