Example Date and Time

Sort By:

Author: Brent Spaulding

There are two fucntions. One to add a number of work days to a data. Another to calculate the number of work days between two dates.

The code also uses a holiday table to inlcude dates that will not be counted as a work day.


This example shows how you can calculate all the dates in a calendar year using three tables. To add an additional year's dates simple add a one record.
This is a sample Access 2000 database. When the databse opens, it checks to see if you have any reminders. If found, you are ask if you want to see them. If you answer yes, then a form opens with a list of the reminders.

Example showing how to work with Time Zones.

 This may also be helpeful:

 Sources for Time Zone and Daylight Saving Time Data