Number of Days

[The Mad Jammer]

I wish to calculate the number of days that have transpired between two dates. My calculation field is LaterDate - EarlierDate. Unfortunately the LaterDate is not always available and the calculation yields a huge negative number. How can I resolve this dilemma? I also want to calculate the average number of days for all the records. I suppose I will have to exclude records without both these dates?

Thanks

The Mad Jammer

And then...there was nothing.

[BobWeaver]

Case(IsEmpty(LaterDate),"",

IsEmpty(EarlierDate),"",

LaterDate-EarlierDate)

To do an average you will have to be careful to make sure it's a weighted average. The field it is weighted by should be a calculated field with this calculation:

cWeighting = not(IsEmpty(LaterDate) or IsEmpty(EarlierDate))

[The Mad Jammer]

Thanks Bob Weaver.

The Mad Jammer