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?