Date Calculation

[tsbpme]

I need to create a calculation so that I can know the number of days a complaint case is opened including the open date, the closing date and all days in between including Saturdays and Sundays. My fields are: Open date and Case closed.

Any help would be appreciated.

[LiveOak]

Days (calculation, number) = closed date - open date + 1

-bd

[RussBaker]

Have a look at some of the date range calculations in the Handy Bits file in the samples section of this forum.

[CobaltSky]

If you want to be able to see the number of days that a complaint case has been open, regardless of whether in has closed yet, you might like to try the formula:

1 + Case(Case closed, Case closed, Status(CurrentDate)) - Open date

---

in a calculation where the result type is set to number and the storage options are set to Unstored.

This will increment progressively while the case remains open (showing number of days open so far) and will cease changing and display the preiod the complaint case was opened once a value is entered in the 'Case closed' field.