7 Replies Latest reply on Sep 12, 2012 2:26 AM by NilsMortenAlexandersen

    Date Calculations problem



      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