Highlighting Overdue Tasks in Portals

[robert2504]

Hi everyone,

I am trying to highlight an overdue tasks on my portal.

This is what I have so far. The name of the task has a calculated value:

Case (Get(CurrentDate) - T_DUE_DATE > 0;

TextStyleAdd(Red(T_NAME);Bold);

TextStyleAdd(Black(T_NAME);Plain))

Red and Black are custom functions; They do work.

Now here is my problem. If I create a task and I entered the due date and that due date is prior to today's date, The task is colored red. For all those tasks that were entered prior and show a due date prior to today, they are ignored. If I go back and reenter the same date, they change the text color to red. I am beginning to think that tomorrow, all those tasks that were due today will not change color to red unless I reenter the date of yesterday. Is there a better solution to marking overdue tasks red. What is the best way to mark them; the field text or the row color?

Thanks

FileMaker Version: Dev 7

Platform: Windows XP

[Ender]

I haven't tried your example, but it looks like your problem could be because the Get(CurrentDate) makes your calc unstored. Unstored calcs don't automatically update.

I think marking overdue tasks in red is a good idea, but you may have to run a script to update the records, or set a flag.

[robert2504]

That sounds logical, I will try putting it in a store field.

Thanks