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