AnsweredAssumed Answered

Correcting a Programmer's Error?

Question asked by ccameron on Aug 6, 2013
Latest reply on Aug 6, 2013 by ccameron

Title

Correcting a Programmer's Error?

Post

     A former consultant entered the following formula to calculate the total number of years a committee member has served, based on start date and [supposedly] calculated to the day the record is accessed.  What makes it difficult is that some members quit for a few years, then came back to serve again so there is a "break in service" element as well.  The field for TOTAL YRS. SERVED is not adding up correctly when we double-check it manually.  What is wrong with this formula and how can I fix it?

      

     If(IsEmpty(end_of_service);

     Round(current_date_check;2);
     Round(get_date_check_check;2))

     The fields being used are: START DATE     BREAK IN SVC:From      BREAK IN SVC:To     TOTAL YRS. SERVED

      

Outcomes