I am currently trying to set up a days in stock field for my products so that i know when to reduce my prices. I have managed to create the formula and is tracking the no. of days i have the product in stock from when the record is created, the problem is i have to manually edit each record before the rule will run and update days in stock. Is there a way to automate this?