Trying to get a field to show the difference between 2 times

[Leea]

We use Crystal Reports 7 in order to report on our dialling activity. We have a couple of time fields that I want to subtract one from the other to give an elapsed time figure. I have to admit to being totally lost, can anyone help...

The two fields are

Maximum ( {General Information.Logout Time} , {@DataGroup2} )
Minimum ( {General Information.Login Time} , {@DataGroup2} )

Any help would be appreciated.

 

[pgtek]

Hi
check the diff date function in cr hlep section for more detail




cheers

pgtek

 

[Madawc]

In Crystal 8.5, you'd do

DateDiff ("d", Maximum ( {General Information.Logout Time} , {@DataGroup2} ), Minimum ( {General Information.Logout Time} , {@DataGroup2} ))


Madawc Williams
East Anglia, Great Britain