<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
SQL query 4 weeks 3 business days
SQL query 4 weeks 3 business days
Rate Topic
Display Mode
Topic Options
Author
Message
DaveDB
DaveDB
Posted Monday, March 11, 2013 9:19 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, March 25, 2013 9:57 AM
Points: 22,
Visits: 77
Hello,
I need to write a query that returns a result set that is within the past 4 weeks and 3 business days. For example, the result set for today would return everything from Feb 6th forward. (Date of this post was March 11).
I have the second part but I am not sure how to include the 3 days. Any help would be appreciated.
select dateadd(week,-4,getdate());
-Dave
Post #1429340
Eugene Elutin
Eugene Elutin
Posted Monday, March 11, 2013 9:29 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 10:39 AM
Points: 2,556,
Visits: 4,398
David Mando (3/11/2013)
Hello,
I need to write a query that returns a result set that is within the past 4 weeks and 3 business days. For example, the result set for today would return everything from Feb 6th forward. (Date of this post was March 11).
I have the second part but I am not sure how to include the 3 days. Any help would be appreciated.
select dateadd(week,-4,getdate());
-Dave
4 calendar weeks Monday to Friday is possible but for "3 business days" you will need a calendar table, as there is no universal definition for the "business day". For example, today, 11th March 2013, is business day in UK, but bank holiday in Victoria - state of Australia (local 1st May
!).
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help
Post #1429348
DaveDB
DaveDB
Posted Monday, March 11, 2013 9:46 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, March 25, 2013 9:57 AM
Points: 22,
Visits: 77
Thanks so much for your quick response.
How would I write this query if it is just (- 4 weeks and 3 days)?
Post #1429353
Eugene Elutin
Eugene Elutin
Posted Monday, March 11, 2013 9:53 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 10:39 AM
Points: 2,556,
Visits: 4,398
Calendar weeks or working weeks?
What is your definition of a week? Is it Monday To Friday? Is it Monday to Sunday?
Is it Sunday to Saturday? Or may be even (as in some middle-east countries) Saturday to Wednesday?
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help
Post #1429360
ScottPletcher
ScottPletcher
Posted Monday, March 11, 2013 5:09 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 3:56 PM
Points: 1,324,
Visits: 1,778
David Mando (3/11/2013)
Thanks so much for your quick response.
How would I write this query if it is just (- 4 weeks and 3 days)?
select dateadd(day, -3, dateadd(week,-4,getdate()));
SQL DBA,SQL Server MVP('07, '08, '09)
One man with courage makes a majority. Andrew Jackson
Post #1429541
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
