<div>
You may need to tweak the values of -6 and +1 to get the precise definition of &quot;last week&quot; that you are looking for.<br />
<br />
Glad to help.
</div>


You may need to tweak the values of -6 and +1 to get the precise definition of "last week" that you are looking for.

Glad to help.

<div>
<div class="content wysiwyg-content">
I am using the following WHERE clause to attemp to pull only data from LAST WEEK from a table<br />
<br />
WHERE DatePart(&quot;ww&quot;, [15th_St_Panel_Plant_FPY.P<wbr />roductionD<wbr />ate]) = (DatePart(&quot;ww&quot;, Date())-1) AND DatePart(&quot;yyyy&quot;, [15th_St_Panel_Plant_FPY.P<wbr />roductionD<wbr />ate]) = (DatePart(&quot;yyyy&quot;, Date()));<br />
<br />
<br />
However, when I compare the query return to manually calculated data from Last Week, the numbers do not match.<br />
<br />
The ProductionDate is in the format mm/dd/yyyy. The first day of the week is intended to be Sunday.<br />
<br />
Is there something in my Syntax, or am I just wrong in trying to do it this way?
</div>
</div>


I am using the following WHERE clause to attemp to pull only data from LAST WEEK from a table

WHERE DatePart("ww", [15th_St_Panel_Plant_FPY.ProductionDate]) = (DatePart("ww", Date())-1) AND DatePart("yyyy", [15th_St_Panel_Plant_FPY.ProductionDate]) = (DatePart("yyyy", Date()));


However, when I compare the query return to manually calculated data from Last Week, the numbers do not match.

The ProductionDate is in the format mm/dd/yyyy. The first day of the week is intended to be Sunday.

Is there something in my Syntax, or am I just wrong in trying to do it this way?

My WHERE Clause Using DatePart is Not Working the Way I Need it to

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.