AnsweredAssumed Answered

Date Calculations problem

Question asked by NilsMortenAlexandersen on Sep 11, 2012
Latest reply on Sep 12, 2012 by NilsMortenAlexandersen


Date Calculations problem


     God morning


     I have a DB with Start Date and Due Date fields, and I have created a field that count the difference between Due Date and Current Date   i.e.   1 day left ... 1 day overdue

     I also have a Status field, with a "Completed" selection (one of many selections from the value list)

     Whem I assign the state of COMPLETED to a task or project (or whatever) I need the DATE DIFFERENCE field to stop calculating the difference, and go to a state of ZERO or EMPTY (and remain there)  ......... or somehing that creates the same effect

     Any ideas ?

     Thanks in advance