This is always an issue, and I have tried many times to work this out in a
non-programmatic, non-unsupported way. But here's what I'm thinking:
Make a Create rule for each activity type that evaluates the "Due Date"
field. Once it goes past the due day (say a day), close the activity...
The problem is that there is no way to evaluate a NOW() type date with the
due date. So now I'm thinking, can you create a date field in each activity
form that will be updated (via the wait timer in workflow) everyday. Now
there's a date with which we can compare with the due date field. So now when
the "Now" date field is greater than (ie one day past), the activity status
will move to closed.
Has anyone tried this?? Will it work?? (I've been pondering this all night
and I'm off today, so I curious to see if this is viable)
--Dodd