Re: Date Conversion Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 09/12/04 

Date: Sat, 11 Sep 2004 22:10:09 -0400

What format are the week and day in? Numbers? Maybe you could do something
like:

SELECT DATEADD(dd, 5*7+2, CONVERT(datetime, '20030101'))

Assuming week 5, day 2 of 2003...

"John A Kushwarra" <JohnAKushwarra@discussions.microsoft.com> wrote in
message news:C9A69BBF-B70F-4ECE-AABB-CE91D273C0D3@microsoft.com...
> Given a year, week and day I need to convert that to a date. Any help
would
> be greatly appreciated