Link to home
Start Free TrialLog in
Avatar of Gianni
GianniFlag for Italy

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.

ASKER CERTIFIED SOLUTION
Avatar of for_yan
for_yan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gianni

ASKER

I accepted two solutions, because they gived me what I need: two options that can be followed to develop a functionality to calculate a date that takes care of working days.
Regards.