I am creating an
application for case management. A case can have a status of being open, closed or pending. When a case is put into 'pending' status, a date is set for the status to change to 'open'.
The idea is so that users have a work queue (dashboard report) which only shows cases in open status, not pending or closed.
Any advice appreciated