Days open unless Status = Closed, then stop. | Discussions

Expand all | Collapse all

Days open unless Status = Closed, then stop.

  • 1.  Days open unless Status = Closed, then stop.

    Posted 11-20-2017 18:58
    I need a days open field to count up, UNLESS another field (Status) is equal to closed. If Status is is equal to closed, the days open should stop at the number of days between creation and the date the Status was marked closed.


  • 2.  RE: Days open unless Status = Closed, then stop.

    Posted 11-21-2017 20:42
    this is the formula from one of my apps for the exact same purpose.  

    If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])


  • 3.  RE: Days open unless Status = Closed, then stop.

    Posted 11-21-2017 20:51
    Mike,
    Do you have a field for [Date Closed] or does that also need to be captured when the Status changes to Closed.


  • 4.  RE: Days open unless Status = Closed, then stop.

    Posted 11-21-2017 21:06
    Good point.  I should have pointed out that the field [date - closed] is populated by form rule when the record is saved and the value of [status] has changed to "closed".