UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Generalized Holidays, Access 2007    
 
   
azolder
post Oct 13 2015, 03:47 PM
Post#1



Posts: 2,428
Joined: 12-February 15
From: SW AZ


I appears to me holidays are traditionally handled in Access by someone inputting the holiday name and date into the database, for a number of years. Computation accuracy are limited to dates input.

This database demonstrates a mechanism to perpetually generate holiday listings based on their definitions, limited only by the years in tblYears, which is much easier to maintain than a table of individual holidays. Changing company policy and legal holidays are accommodated by including a range of effective dates.

Holiday types supported are:
  • Gregorian Day of Month
  • Gregorian Nth Weekday of Month
  • Easter and Easter Offsets
  • Advent Sundays
  • Hebrew/Jewish Day of Month
  • Hijri/Arabic/Islamic Day of Month

The handling of weekends is another sticky point. Typically they are hard coded into applications, and assume typical Saturday/Sunday holidays. But weekends are cultural and mater of company policy.

This database demonstrates a mechanism to accommodate different weekend day scenarios, including accounting for changes.

Weekends also bring up the issue of holiday observation. There are three classes of holiday observation
  • None - The holiday is not observed, that is there is no 'day off' for it.
  • Weekdays Only - The holiday is observed (a day off) only on weekdays. It is not observed on weekends.
  • Nearest Weekday - The holiday is observed. When it falls on a weekend it is observed on the "nearest workday".


Attached File  HolidaysXX.zip ( 226.65K )Number of downloads: 159
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    10th December 2017 - 11:14 PM