<div>
Was hoping to get it from week of year but I can work with this
</div>


Was hoping to get it from week of year but I can work with this

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a week number for a year<br />
<br />
Completed Date = '01-04-2012'<br />
<br />
select datepart(wk,CompletedDate)<wbr /> <br />
<br />
Which returns a 1<br />
<br />
I need to know what is the saturday date of that week number?<br />
<br />
Thanks<br />
Chuck
</div>
</div>


Hello

I have a week number for a year

Completed Date = '01-04-2012'

select datepart(wk,CompletedDate) 

Which returns a 1

I need to know what is the saturday date of that week number?

Thanks
Chuck

Need Week Ending Date from Week Number

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.