Date warning

[skynight]

I thought I had this working but no...

I want to display the days left for an action, using fields to enter the Due Date for an action, so that the Days Overdue will be displayed. The calculation I am using does this for only the day of entry, whereas I need it to update daily and show a continuous readout of the remaining days before the action is completed. I would also want it to stop calculating from the current date and firm up on a third entry field, Date Completed, so I have a record of the days overdue when it is finally done.

So the calculation is not updating automatically each day, but freezing on the date that I entered the initial value, and it is not reflecting the date of completion.

I would sure appreciate help on this one.

This is what I am using now: If ( Date Completed;Date Completed-Due Date;TextColor(Get(CurrentDate)-Due Date;RGB(0;0;244)) )

Thanks..

[Lee Smith]

Are you trying to flag any project that doesn't have a Date Completed date in it?

If so, try:

Case ( IsEmpty ( Date_Completed ) ; TextColor ( Due Date - Get ( CurrentDate ) ; RGB ( 0 ; 0 ; 244 ) ) )

Lee

[comment]

Your current formula should work - but, like any calculation using Get(CurrentDate), it needs to be unstored in order to update.

[skynight]

Thanks for the help, I will try it today. I would like the calculation to use the current date, but to also look at the Date Completed (another field) and use the older of the two dates to show overdue days. So that it shows outstanding days to go or overdue, but when the project is completed and the date filled, it will freeze for evermore at the correct value, showing when the completed date was in relation to the Due Date.

The Overdue shows a negative number when there is still time to go, is there a way to make it change colour, or font, when it changes to a positive number? Make it more obvious?

Can't tell you how much I appreciate the help.

[comment]

You could try something like:

Let (

diff = Case (not CompletedDate ; Get (CurrentDate) - DueDate ; CompletedDate - DueDate )

;

TextColor ( diff ;

Case ( diff > 0 ; RGB ( 255 ; 0 ; 0) ; 0 )

)

)