You'll probably need to use a workflow action script, in which case you may as well do a scheduled script