WorkDays database

Overview:

Calculating holidays, weekends, and work dates has always been a useful tool in business calendars. Jerry Netherton has created the essential database for this need. It combines both the US and UK calendars into a single calendar. He offers it as a guide to your particular needs and designs.

There are basically 3 tables. The CAL table contains all the relative data. There are 2 Easter calendars with data for at least the next 100 years. The Extended_Easter table is good for about 8,000 years. I suggest you upgrade your systems when you get pretty close to running out the UK Easter data.

There are 2 DQLs that calculate the respective bank holidays and modifies the CAL table. One for the US and one for the UK… By studying and modifying these DQLs, you can add/delete bank holidays as needed.

There are 2 DQLs that modifies the CAL with respect to the number of days within each WorkDay set. This allows you to count the number of workdays between selected date ranges. There is an EXAMPLE table that demonstrates this feature.

There are 2 DQLs that modifies the CAL table with data from the respective Easter tables.

There are 3 versions of the same database here:

The original 4.53 version as donated by Jerry.

A 5.16(7) version that has been upgraded from 4.53, and has added messaging and extended dates.

A DFW version in a DFW 6.1 format. It is a fully working DFW application that illustrates certain screen design elements. It contains a single CDF from Computer Wizard Consulting that illustrates a method of keeping the user informed with progress bars.

There are no user names or passwords in the DFD versions. There are 2 login sets with the DFW version.

One is USER/USER, and the other is Admin/Admin. The USER/USER login takes the user directly to a Menu screen with all pertinent functions for the application available. There is no access to drop down menus or toolbars.

The Admin/Admin login takes the user to the DFW catalogue screen with drop down menus and toolbars available.

This is a Zip of the raw data in a CSV format. The data spans the Dates 01/01/1974 thru 12/31/2074. It includes a workdate Yes/No field. The field has been adjusted to reflect whether the date is a Saturday, Sunday, Easter or National holiday. The day of the week is also reflected in a field. The file is in a basic Mail Merge layout with field names in the first row.

Suggestion is to create a table with the appropriate fields, import the data, and use the table as reference source within your specific application...