AnsweredAssumed Answered

Correcting a Programmer's Error?

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


Correcting a Programmer's Error?


     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?




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