X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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

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: 171
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    11th December 2018 - 08:00 PM