On Tue, Sep 15, 2009 at 5:45 PM, Anthony J. Gundrum <[email protected]> wrote: > Well, if it's week 38 the it must be 38 * 7 days into the year. So take (38 > * 7) and add that to 1/1/year and you'll get the end date (38 * 7) days into > the year. The seed date (1/1/year) is key. You must define what is the > first day of the week (Sat, Sun, Mon, something else) and determine what the > date is for that day of the week for the year you are working in. Take 2009 > for example. 1/1/2009 was a Thursday. This is probably not your starting > day of the week you are imagining. I'll venture to guess that 1/1/2009 > (Thu) to 1/3/2009 (Sat) is week 1 for 2009 and 12/28 (Sun) to 12/31 (Wed) is > week 52 of 2008. Does this sound right? -----------------------
Your first premise is close. What date do you consider the first of the YEAR, not 1/1 YOu have to benchmark the first DOW() that ou want. Oh the joys of this crap! -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
