How To Average a Date Field 1

[keeno]

Hello

I have a date field in my report which shows the amount of time in hours taken to receive payment.

When i try and do a summary fo the field there is no option to obtain the Average.

Does anyone know of any way to get the Average on what is essentially a date field? Is this possible at all?

Really apopreciate anyone's help on this

Cheers

David

 

[Madawc]

I don't follow what you mean by

I have a date field in my report which shows the amount of time in hours taken to receive payment.

If you have two dates, you can find the difference in hours using

DateDiff ("h", {date1},  {date2})

Once you have this field you can get an average from it.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10