Windows Calendar & Holiday functions

[Tim Davidge]

People,

Has anyone had occasion to implement holiday functionality into a calendar
of sorts for scheduled tasks or batch files / scripting ? I'm looking for
suggested ways of implementing the equivalent of say a stock market holidays
feature. If using scripting functions, how
can we set it up so it will not run on specific dates throughout the
financial year ? Examples being July 4th, Christmas, Easter etc.

Any thoughts would be greatly appreciated.

Tim

 

[Ross Presser]

People,

Has anyone had occasion to implement holiday functionality into a
calendar of sorts for scheduled tasks or batch files / scripting ? I'm
looking for suggested ways of implementing the equivalent of say a
stock market holidays feature. If using scripting functions, how
can we set it up so it will not run on specific dates throughout the
financial year ? Examples being July 4th, Christmas, Easter etc.

First decide how long a period of time you need your calendar to cover.
If it's < 50 years, your best bet is probably to create a database table
with all the holidays in it, and consult it at run time using ADO.

For calculating the dates that various holidays fall on, search the web.

The other advantage of such a table is that it allows computations such as
"number of working days between X and Y" to be done with a simple SELECT.

 

[Dr John Stockton]

JRS: In article <#[email protected]>, seen in
Tim Davidge

Has anyone had occasion to implement holiday functionality into a calendar
of sorts for scheduled tasks or batch files / scripting ? I'm looking for
suggested ways of implementing the equivalent of say a stock market holidays
feature. If using scripting functions, how
can we set it up so it will not run on specific dates throughout the
financial year ? Examples being July 4th, Christmas, Easter etc.

Any thoughts would be greatly appreciated.

<URL:http://www.merlyn.demon.co.uk/holidays.htm> contains holiday
information & javascript algorithms, which can be adapted, for BI & NA.

<URL:http://www.merlyn.demon.co.uk/js-dates.htm> links to "Working Days
Ahead", which may be of some help.

I know nothing of stock market holidays - no doubt they depend on
locality, and are not the same in Riyadh, Tel Aviv, & Tokyo; you do not
say where you are.

Note that the rules for moving a dated holiday that otherwise falls on a
weekend are locality-dependent; the Christmas holiday can be as late as
Dec 28th AIUI.