I was hoping that SFDC would add time based rule evaluation to the workflow capabilities.  That is, to run workflow rules without requiring the record to be modified first to trigger the rule.

 

My example is we allow some accounts be have a protected status as long as they have certain activity in a certain time period.  I've created the field that shows the days since said qualified activity occured, I have a workflow that will change the protected status based on the value in that qualified activity age field.

 

However, the rule only runs when someone modifies the account, so accounts can be falsely protected simply by not editing them.

 

I'm trying to find a way to make this rule run periodically without the modification.

 

Any suggestions?

 

Thanks,

 

Michael