We have a query that runs that identifies certain constituents who did "foo" yesterday. I created an attribute "last foo date" on constituent, and would like to globally update that attribute with yesterdays date for all the people who did "foo" yesterday. It works manually like a champ.

Now I want to automatically run it every night at 10pm.