Good Afternoon,
I've been asked to build a task based system for keeping track of daily, weekly and monthly task that the administrators do at our office, things like change this, burn this, etc.
I'm interested in thoughts on how I can achieve a stable, fools proof system. I've given this a lot of thought, and come up with the following:
Two tables
Tasks and instances
Each task has a next run date and this is calculated when the task is entered. When the page for todays task is accessed, the list of instances is build for today, which is calculated from the next run date.
Weekends are taken into account.
I'm not interested in code (mmm, i'm posting this in the code forum, forgive me Mr Mod, forgive me 😃 ).
Comments would be appreciated.
🙂
