Skip to main content
Question

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

  • May 9, 2019
  • 0 replies
  • 24 views
Forum|alt.badge.img+7
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.
    This topic has been closed for replies.

    Forum|alt.badge.img+14
    If(IsNull([Date Closed]),Today()-[Date Case Opened],null)
    Laura Thacker | laura@intelligentdbs.com | (626) 771 0454
    • AustinK
    • Registered
    • May 9, 2019
    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
    )
    Terms & ConditionsAccessibility statement