I'm trying to generate a field that will display the amount of days left until a project is due. Currently all that is set up is a simple calculation that takes the due date and subtracts the current date. But obviously the problems begin when the project is completed and the due date has passed (ie it looks like the project is overdue). I don't want to confuse this for actual projects that are overdue either. I have a drop down list that prompts the user to say whether the project has been completed/cancelled/defered etc. and what I want is for when a selection is made it updates my "Due In" Field

I've included my script as it is so far, (it doesn't work at the moment) but if anyone could make some suggestions that would be great

If [Tasks::Status="Complete" or Tasks::Status = "Cancelled"]

Set Field[Tasks::Due in; -2000] //I have figured //-2000 is sufficiently outside a possible //overdue date

Else

Set Field [Tasks::Due In; Tasks::Due Date - Get (Current Date)]

End If

How about:

Set Field [ Tasks::Due in ; Case ( Tasks::Status ≠ "Complete" and Tasks::Status ≠ "Cancelled" ; Tasks::Due Date - Get (Current Date) ]

It seems that "Due in" could be a calculation field - no scripted setting required.

Worked! Thanks

I should mention that I had to modify it slightly to work correctly, but otherwise it was the right idea, here's what it looks like now:

Case ( Status="Complete" or Status="Defer";-2000;

Due Date = "";"";

Due Date - Get ( CurrentDate ))

Due Date = "";"";

What is that ?