Example Date and Time

Display:

Add work days and calculate net work days
 441 Downloads
 21.29 KB
 03-12-2016

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.

 

Generate a list of dates in a year.
 1245 Downloads
 10.76 KB
 03-12-2016

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.

Reminders
 3537 Downloads
 16.65 KB
 03-12-2016

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.

Time Zones
 1264 Downloads
 12.78 KB
 03-12-2016

Example showing how to work with Time Zones.

 This may also be helpeful:

 Sources for Time Zone and Daylight Saving Time Data