Gianni
asked on
Create working schedule's that take heed of working days and holidays
I have an application for the management of Prevenive maintenance based on access database or mysql.
After setting up maintenance frequency and date of first pm, the application generate reports for the preventive maintenance schedule, with the information of the dates of scheduled maintenance.
The problem is that the application doesn't take care of holidays,saturdays and sundays, when calculating the next date for preventive maintenance.
Is there any thechnical solution to this problem? Should be created a teble with the indication of holidays, saturdays and sundays calendar?
Regards, Gianni.
After setting up maintenance frequency and date of first pm, the application generate reports for the preventive maintenance schedule, with the information of the dates of scheduled maintenance.
The problem is that the application doesn't take care of holidays,saturdays and sundays, when calculating the next date for preventive maintenance.
Is there any thechnical solution to this problem? Should be created a teble with the indication of holidays, saturdays and sundays calendar?
Regards, Gianni.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regards.