I need to have a container field change to indicate how close the
Jobs::DueDate is, if its 4 days away light blue, if its 1 day away
bright red.

I am able to get it all to work until the next day comes, then I need
to go through all the DueDate fields and change the due date  so my
calculation for that field will work. the calc is
DayOfYear(DueDate) - DayOfYear(Get(CurrentDate))

I want to have this updated all the time so the container field is kept
up to date.

I was thinking of a script to loop through the due date field, but I
could not see how to go to the next record in a found set using a
script


I am sure this can be done, I must just be looking at it from the wrong
angle

Make the calculation unstored.
Where you entered the calculation formula, click the "Storage Options"
button, then the "Do not store calculation results" checkbox.  That
will cause FM to automatically recaculate it every day.

thanks :)