Bank Holiday Problem

1. Senior Member
Join Date
Dec 1969
Posts
787

## Bank Holiday Problem

I&#039;ve built web application which deals with the requesting/authorising of holidays within our company. Unfortunately, I&#039;ve overlooked something which has just been pointed out - BANK HOLIDAYS!<BR><BR>I could quite easily have someone enter the bank holidays for the year into a table and check against that, but I&#039;d prefer a way to do it programatically.<BR><BR>I&#039;ve heard of something called the Carter algorithm which calculates the date of easter between 1900 and 2099 but I&#039;m not sure if this could be used to calculate other holidays.<BR><BR>Any help would be appreciated.<BR><BR>Pete.

2. Senior Member
Join Date
Dec 1969
Posts
787

## RE: Bank Holiday Problem

OK - I phrased that a bit daft. It&#039;s probably not possible to calculate the bank holidays. I would have thought there would be an online resource, though, which would be queryable. If there isn&#039;t, then someone should really think about setting it up.<BR>

3. Senior Member
Join Date
Dec 1969
Posts
16,931

## RE: Bank Holiday Problem

If there isn&#039;t, then someone should really think about setting it up.<BR>Because it&#039;s then their problem to update and maintain it and not yours?!<BR><BR>;-)<BR><BR>Now, if it was a pay-per-use resource, I&#039;d consider setting up a web service for it, but I&#039;d need to make it worth my while to update each annum.<BR><BR>Craig.

4. Senior Member
Join Date
Dec 1969
Posts
787

## RE: Bank Holiday Problem

Heh! Yeah - the pay per use was definitely on my mind. <BR><BR>It looks like most people use db tables and update them when they need to. My date difference calculation is done in vbscript in the page, so I&#039;m thinking of putting an array of dates as an application variable, (0101,BH;0201,WD;0301,WD...) where BH=Bank Holiday and WD=Work Day. I just can&#039;t help thinking that looping through that&#039;s gonna have an overhead I don&#039;t want. Maybe just selecting bank holidays from a table in the db would be the best idea.

5. Junior Member
Join Date
Dec 1969
Posts
2

## RE: Bank Holiday Problem

I&#039;m looking to build a holiday request database for my companies intranet (line managers authorisation etc). Could you give me some pointers as to where I might start finding what code I need to build this with .net?<BR><BR>Thanks in advance.

6. God
Senior Member
Join Date
Dec 1969
Posts
18,177

## Actually, most holidays..

.. ARE calculatable, with a handful of exceptions.<BR><BR>I&#039;ve long thought about setting up a service to do just that.<BR><BR>:-)<BR><BR>US Holidays on my calendar at ourfamilyheart.com.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•