We're looking to auto increment a number value field on Cases by 1 for every day the case has been open (i.e. auto-increment as long as the case is not closed).
What would be the best way to go about this? A time based workflow action wouldn't get me what I need. I tried a formula field, but, I'm not sure that it would work without referencing the formula field itself.
Does anyone have any ideas?