Date Calculations problem
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