I want to insert a field in a form to countdown the days
until an event occurs. I want the field to show how many
days until the last event expires. For example.
Joe Snuffy performed this task on 1-Jan-03. He has 90
days until he has to perform that task again. If today is
3-Jan-03 he has 88 days until that event has to be
accomplished again. I want the field to automatically
calculate and show the 88 days.
That is what I needed. Now I just need to tweak it a little bit. What I did was
That gave me the number. The only problem is, that when they are still within the time period to accomplish the task, then it shows a negative number. When they're past they're due date, it shows a positive number. Is there any way of changing this to show the negative number for post due date, and show a positive number for the pre due date? I know this is picky, but I understand it, but others that I work with might not.
Also is there a way to change the color of the number if they're past their due date to red? Say they're within their qualification time, then it would be a black positive integer, and if they're past their qualification date, then it would be a negative red number.