4 Replies Latest reply on Jan 11, 2017 7:59 AM by bruns

    Date Calculation

    bruns

      Can I get some assistance with a date calculation.  I have a field called open and a field called closed.  I have the 3rd field called days open.  I currently have a calculation

      closed - open

       

      This give me a number if I have a closed date.  Where I need help is if I do not have a closed date yet, what would the calc be to still give me the days open and when I put a closed date in, it stops counting.

       

      I appreciate any help.