bruns

Date Calculation

Discussion created by bruns on Jan 11, 2017
Latest reply on Jan 11, 2017 by 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.

Outcomes