Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
6 years ago

I want to calculate the number of days a case was open but only if the case was not closed

I have a field titled "Date Case Opened" and want to calculate the # of days the case was open but only if the "Date Closed" filed is blank.
Formulas and functions
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    If you care about it being business days only instead of the full week you can also do it this way.

    if(isNull([Date Closed]),
    WeekdaySub(Today(),[Date Case Opened]),
    null
    )