|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#2
June 10th, 2004, 12:25 PM
|
||||
|
||||
|
I have come up with a suitable solution for this problem.
If you are curious here is the function that I created to correctly caculate the datediff with out weekends. Code:
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION dbo.WorkDayDiff (@BegDate datetime ,@EndDate DATETIME) RETURNS int BEGIN Declare @NumWeek int set @BegDate = isnull(@BegDate,0) set @EndDate = IsNull(@EndDate,0) set @NumWeek = DateDiff(ww, @BegDate, @EndDate) Return (datediff(dd, @BegDate, @EndDate) - (@numWeek * 2)) END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
|
|
#3
June 11th, 2004, 07:19 AM
|
||||
|
||||
|
good start
 however, it only works if neither begindate nor enddate is a weekend date! Code:
declare @BegDate datetime declare @EndDate datetime declare @numWeek int set @BegDate = '2004-06-12' set @EndDate = '2004-06-13' set @NumWeek = DateDiff(ww, @BegDate, @EndDate) select (datediff(dd, @BegDate, @EndDate) - (@numWeek * 2)) result: -1
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Number of days between two dates, w/o Weekends |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
