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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-20 : 09:35:27
|
Stéphane writes "Hi,
I got a way to calculate difference between dates, using this query :
SELECT DateDiff(day,DateJourZero,ReClient_SAC) AS [Client SAC Réel - Date Jour Zéro] , DateJourZero,ReClient_SAC,NoUSSO FROM tbltest;
0 2001-03-06 2001-03-06
0 2001-02-08 2001-02-08
14 2001-04-19 2001-05-03
And it worked..... but the problem is : I want to calculate work days difference!!! that means, in the count, I don't want any week-end days, and I don't want special days like Independance day , or Queens day for Canada..... Dunno if this will stomp you .... but I haven't found a solution for that , except for an ASP script, but I want my code as optimized as possible , so I want to use a SQL QUERY. I use SQL server....thanks guys!
Archangel" |
|
|
|
|
|
Difference between dates