Results 1 to 2 of 2
  1. #1
    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?


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts