InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 03:18:36 GMT20http://www.sqlservercentral.com/Forums/Topic507411-1301-1.aspxSays here that DATEDIFF doesn't consider DATEFIRST.https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=239958Wed, 28 May 2008 08:43:03 GMTPat Reiterhttp://www.sqlservercentral.com/Forums/Topic507411-1301-1.aspxI don't think that datediff(wk) salutes @@DateFirst.[font="Courier New"]DateFirst StartDate EndDate DateDiff WeekDiff --------- ----------- ----------- ----------- ----------- 7 Sun 25May08 Mon 26May08 0 0 7 Mon 19May08 Sun 01Jun08 2 2 7 Sat 24May08 Sun 25May08 1 1 DateFirst StartDate EndDate DateDiff WeekDiff --------- ----------- ----------- ----------- ----------- 1 Sun 25May08 Mon 26May08 0 1 1 Mon 19May08 Sun 01Jun08 2 1 1 Sat 24May08 Sun 25May08 1 0 [/font]Wed, 28 May 2008 08:29:03 GMTPat Reiterhttp://www.sqlservercentral.com/Forums/Topic507411-1301-1.aspxCouldn't you just use the following?SELECT DATEDIFF(wk,@StartDate,@EndDate)Wed, 28 May 2008 07:13:52 GMThayden-508426http://www.sqlservercentral.com/Forums/Topic507411-1301-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/62805/">Difference between two dates in weeks</A>[/B]Tue, 27 May 2008 22:46:11 GMTspindoctor