Stereo239


Hi,

Does SQL server 2005 provide a function to determine future BUSINESS day What about holidays I sthere a way to feed a holiday file into a table and have SQL Server determin if the future date falls on a business day




Re: date function/tool to determine future business days/ holidays

Jens K. Suessmeyer


As far as you do not mean the fixed calculated public holidays (like Easter, which can be calculated with a Gauss formula) you will have to implement that on your own having a custom table with the special dates.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---







Re: date function/tool to determine future business days/ holidays

Stereo239

Thanks but I am still unclear. If I'd like to know if today's date + 100 days from now would fall on a business day . Is there a ready-to-use MS SQL function that I can use or should I write it on my own






Re: date function/tool to determine future business days/ holidays

Jens K. Suessmeyer

Well, define business day. There is not a common understanding of business day (even in one countrym like here in Germany :-) )

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---






Re: date function/tool to determine future business days/ holidays

Solomon Rutzky

Hello. I think the following library of functions can help with the issue of finding Business Days:

http://www.SQLsharp.com/

I just added some date functions and one of them is finding the number of business days within a given date range. And because not everyone can agree on what is a business day, the function allows the user to select which days are to be filtered out as non-business days. I have not done a function to find if a particular day in the future is a business day, but that can be added quite easily. This function can determine holidays on any given year so you don't need the typical holiday table that most people suggest using.