Thread: How to schedule based on time
10-17-12, 00:16 #1Registered User
- Join Date
- Oct 2012
Unanswered: How to schedule based on time
I'm trying to figure out how to Calculate for scheduled Inspection on equipment. I have 200 individual machine that I need to schedule for reaccurring inspections. Some get Weekly, Bi-Weeekly, Monthly and Yearly. As I start this I will be assigning dates over a period of time so they do not all appear the same day and overwelm the maintenance staff.
So Machine 1 gets a monthly inspection on November 1 and every month there after on the 1st of the month. How do I go about this type of setup?
10-17-12, 00:45 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
Store a date last inspected
Store a flag that identifies the inspection interval.
Runaway report that identifies equipment which is due for inspection based on the last inspection date plus the interval. That report should be able to identify overdue inspections.
Id suggest the inspection interval is stored as days in another table with a FK in the equipment table pointing to the interval definitions table.I'd rather be riding on the Tiger 800 or the Norton