calculating holidays

[weeze2]

Hi Is there a way to calculate holidays in JavaScript

The VBA below does that by calculating Easter and then adding or subtracting some days to get to the rest.

I have tried to convert the code to JavaScript - the easter calculation works but the other holidays does not. Is it possible to calculate holidays just by using Easter as a fixpoint, and has anybody tried this in JavaScript before?

http://www.projectum.dk/default.aspx?pid=1111&id=1111

 

[scorpio66]

It's really difficult to get Easter calculations right - there is a whole page of information about calculating Easter here:

http://www.cs.rutgers.edu/pub/soc.religion.christian/faq/easter-date

and more here:

http://www.bbc.co.uk/dna/h2g2/A653267

Actually, public holidays are a pain in general, especially if your hoping to cover more than just England.

I'd pre-calulate ALL bank holidays for as far forward as you can get them and store them in a database somewhere.

Don't forget, public holidays can be added at will (didn't we get an additional public holiday in 1977 for the Queens Silver Jubilee) and this would require you to change your algorithm, as opposed to just setting a flag on a database record.

Chaz

Chaz

 

[scorpio66]

Actually, the extra bank holiday was in 2002 for the Queens Golden Jubilee.

They added an extra day (June 3rd) and moved the end of May holiday to June 4th for a 4 day weekend.

See what I mean.

Chaz