Viewing 8 posts - 1 through 8 (of 8 total)
the 'where' clause in the two select statements was different.
May 14, 2009 at 8:12 am
andrewd.smith (4/21/2009)
ISNULL(NULLIF(compdte, 0), GETDATE())
A datetime value of '1900-01-01 00:00:00.000' is 0 (zero) when the datetime is converted...
April 21, 2009 at 12:23 pm
Arun Sathianathan (4/21/2009)
Check the below article that answers your requirement
No, it doesn't.
I have code that calculates workdays already:
Select callnbr,entdte,compdte,
CASE WHEN DATEDIFF(day, entdte, compdte) - (2 * DATEDIFF(week, entdte, compdte)) -...
April 21, 2009 at 10:48 am
Arun Sathianathan (4/21/2009)
Is it not simple as below. Please state your requirement otherwise
It has to factor in weekends...
April 21, 2009 at 9:25 am
Thanks Bob,
I'll give a whirl. I really, really appreciate it.
April 8, 2009 at 12:45 pm
Bob Hovious (4/6/2009)
Jeff, let us know if you have any questions.
Ummm...yeah...I'd really just like to know what lines I need to change in that view to count Saturdays as workdays....
The...
April 7, 2009 at 6:21 am
Viewing 8 posts - 1 through 8 (of 8 total)