I am building a simple holiday planner for drivers who are available or not available on a daily basis. The database consists of a table with drivers names and ID and a table with holidays or days off. The method of booking holidays is based on name, begin date, end date and approval.
What i want to do is be able to open a list of all drivers available to work so that i can fill in a plan board. The list should show all the drivers and on the days that the driver is not availble a code "off" or "NA". The biggest problem is that the date range has to show weekends as i want to plan 7 days a week. Unitll now i have only found scripts that work with weekdays and not incl. weekends.
Can anyone help me with this please?
What i want to do is be able to open a list of all drivers available to work so that i can fill in a plan board. The list should show all the drivers and on the days that the driver is not availble a code "off" or "NA". The biggest problem is that the date range has to show weekends as i want to plan 7 days a week. Unitll now i have only found scripts that work with weekdays and not incl. weekends.
Can anyone help me with this please?