<div>
read this <br />
<a href="http://bytes.com/forum/thread757389.html" rel="ugc">http://bytes.com/forum/thread757389.html</a><br />
or <br />
<a href="http://www.sqlservercurry.com/2008/04/find-first-and-last-day-of-each-month.html" rel="ugc">http://www.sqlservercurry.com/2008/04/find-first-and-last-day-of-each-month.html</a>
</div>


<div>
Hi knuckle05,<br />
<br />
Does this do what you want?<br />

<pre><code class="code-1 nolinks" id="code-120315"><span>SELECT</span>
<span>	CASE DATEPART(dw,GETDATE())</span>
<span>		WHEN 7 THEN GETDATE()</span>
<span>		ELSE DATEADD(dd,-DATEPART(dw,GETDATE())+1,GETDATE())</span>
<span>	END</span>
</code></pre>
</div>


<div>
DATEADD(d, -DATEPART(w, getdate()), getdate())
</div>


<div>
oops, that should have been a 1<br />

<pre><code class="code-1 nolinks" id="code-120320"><span>SELECT</span>
<span>	CASE DATEPART(dw,GETDATE())</span>
<span>		WHEN 1 THEN GETDATE()</span>
<span>		ELSE DATEADD(dd,-DATEPART(dw,GETDATE())+1,GETDATE())</span>
<span>	END</span>
</code></pre>
</div>


<div>
Oops, that's saturday. <br />
<br />
DATEADD(d, 1-DATEPART(w, getdate()), getdate())
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Based on the current date using GETDATE(), I'd like to determine the date of the previous Sunday, and if the current date IS Sunday, then that date would be returned.<br />
<br />
Can someone help me?<br />
<br />
Thanks!
</div>
</div>


Hi All,

Based on the current date using GETDATE(), I'd like to determine the date of the previous Sunday, and if the current date IS Sunday, then that date would be returned.

Can someone help me?

Thanks!

How to find previous sunday's date in T-SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.