Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 date diff for working day

Author  Topic 

MattieBala69
Starting Member

30 Posts

Posted - 2005-11-08 : 12:56:28
Hey ,
I was wondering if anyone could help me
I need to do a datediff
eg lets say ReqDate was Nov 1 and Rec Date is null
i need the datediff to show the working days so the answer should be 5
How would i do that .
Thank you,
Mattie

nr
SQLTeam MVY

12543 Posts

Posted - 2005-11-08 : 12:57:40
Between which dates?
How do you decide on bank holidays?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-11-08 : 13:02:14
Like this

http://weblogs.sqlteam.com/brettk/archive/2005/05/12/5139.aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -