<div>
it looks ok for me.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-43008513-1"><span>select DATEPART(yyyy, DATEADD(m, - 1, '1 Jan 2020')),  DATEPART(m, DATEADD(m, - 1, '1 Jan 2020'))</span>
<span>select DATEPART(yyyy, DATEADD(m, - 1, '1 Feb 2020')),  DATEPART(m, DATEADD(m, - 1, '1 Feb 2020'))</span>
<span>select DATEPART(yyyy, DATEADD(m, - 1, getdate())),  DATEPART(m, DATEADD(m, - 1, getdate()))</span>
</code></pre>
<br />
can you provide sample data that &quot;got the issues&quot;?
</div>


IT Technical

HKFuey

<div>
you could also try like this:<br />
<br />
SELECT * FROM Table<br />
WHERE &nbsp;MONTH(Date) = &nbsp;<mark>MONTH(</mark> DATEADD(MONTH, -1, [Date]))<br />
AND YEAR(Date) = &nbsp; &nbsp;<mark>YEAR(</mark> DATEADD(MONTH, -1, [Date]))
</div>


<div>
<b>No. &nbsp;Never</b> use a function against a table column if you can avoid it. &nbsp;This is the proper way to do the check you want to do:<br />
<br />
WHERE &nbsp; &nbsp; &nbsp; &nbsp;dbo.SLPostedCustomerTran.T<wbr />ransaction<wbr />Date &gt;= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0) AND dbo.SLPostedCustomerTran.T<wbr />ransaction<wbr />Date &lt;&nbsp;DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)
</div>


<div>
<div class="content wysiwyg-content">
I have a SQL view with the criteria below, I'm trying to get last months transactions. My criteria works most of the time except in month 1 of the year.<br />
<br />
WHERE &nbsp; &nbsp; &nbsp; &nbsp;(DATEPART(yyyy, dbo.SLPostedCustomerTran.T<wbr />ransaction<wbr />Date) = DATEPART(yyyy, DATEADD(m, - 1, GETDATE()))) AND (DATEPART(m, dbo.SLPostedCustomerTran.T<wbr />ransaction<wbr />Date) = DATEPART(m, DATEADD(m, - 1, GETDATE())))<br />
<br />
Can anyone help?
</div>
</div>


I have a SQL view with the criteria below, I'm trying to get last months transactions. My criteria works most of the time except in month 1 of the year.

WHERE        (DATEPART(yyyy, dbo.SLPostedCustomerTran.TransactionDate) = DATEPART(yyyy, DATEADD(m, - 1, GETDATE()))) AND (DATEPART(m, dbo.SLPostedCustomerTran.TransactionDate) = DATEPART(m, DATEADD(m, - 1, GETDATE())))

Can anyone help?

SQL filter for last months data

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.