InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 13:06:18 GMT20http://www.sqlservercentral.com/Forums/Topic1429340-391-1.aspx[quote][b]David Mando (3/11/2013)[/b][hr]Thanks so much for your quick response.How would I write this query if it is just (- 4 weeks and 3 days)?[/quote]select dateadd(day, -3, dateadd(week,-4,getdate()));Mon, 11 Mar 2013 17:09:48 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1429340-391-1.aspxCalendar 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?Mon, 11 Mar 2013 09:53:53 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1429340-391-1.aspxThanks so much for your quick response.How would I write this query if it is just (- 4 weeks and 3 days)?Mon, 11 Mar 2013 09:46:00 GMTDaveDBhttp://www.sqlservercentral.com/Forums/Topic1429340-391-1.aspx[quote][b]David Mando (3/11/2013)[/b][hr]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[/quote]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 :-)!).Mon, 11 Mar 2013 09:29:28 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1429340-391-1.aspxHello,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());-DaveMon, 11 Mar 2013 09:19:51 GMTDaveDB