AnsweredAssumed Answered

Calculation Issue

Question asked by bruns on Dec 9, 2013
Latest reply on Dec 11, 2013 by bruns

Title

Calculation Issue

Post

     We have vessels, I have a date on field (date_on) and a dateoff field (date_off).  I have this in a portal.  I have a field to calc the number of days on vessel by using the 2 dates.  My issue is, I have someone that I have a date on for but they have not gotten off yet, the system put a ? in the field and therefore it will not count the other dates.  When it show up in my report, it has a negative number .  I assume all of this is because I have not put a date off in yet, what can I do or is there  a script that will work around?  Thanks if you can help.

Outcomes