Determining the number of business days between two dates

Question

Determining the number of business days between two dates

kam7395

Old Hand

Points: 395
More actions
June 12, 2009 at 9:57 am

#201389

Hello Everyone,
I am new to SQL Server 2000, I would like to know how to "determine the number of business days between two dates". (e.g. how to find the number of business days between the hiredates of two employees.)
Any help is greatly appreciated.
Thanks in advance!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

Hi,

I just used your question "determine the number of business days between two dates" and searched for exactly the same string on this site (search function on the upper right hand side).

Top 1 hit was http://www.sqlservercentral.com/articles/Advanced+Querying/businessdays/309/ which should exactly do what you'Re asking for.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

kam7395 Old Hand Points: 395 More actions · Answer 2

kam7395

Old Hand

Points: 395

June 12, 2009 at 3:16 pm

#1008914

Thanks a lot!

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 3

If all you want is to calculate week days, there's a very short function at the following article.

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

If you want work days instead of week days, I suggest you Google for "Calendar Table".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)