To break the problem down to it's simplest form, I have a case statement that looks at a field "Modified Today" and if the field is today return Active else return Inactive. Sounds easy, the problem starts tomorrow when the field never gets re-evaluated for Inactive.
I can unstore the field so it's get evaluated during browsing but I have a portal on a another database that looks up my active work but is empty due to the unstored field.
Any ideas? Below is the Case Statement:
Case(Modified Date = Today,"Active",
Order_Status = "Job In" , "Active",
Order_Status = "Progress" , "A