<div>
Are you trying to display all records where NextDate is between PAST_DUE date and current dat?<br />
<br />

<pre><code id="code-20-42118836-1">Where Status = 'pending' AND NextDate BETWEEN PAST_DUE AND GETDATE()</code></pre>
</div>


Are you trying to display all records where NextDate is between PAST_DUE date and current dat?



Where Status = 'pending' AND NextDate BETWEEN PAST_DUE AND GETDATE()

<div>
I AM TRYING TO DISPLAY ALL RECORDS WHERE NEXTDATE IS EITHER PAST DUE OR IN THE CURRENT WEEK. &nbsp;SO IF IT'S MONDAY MAY 1, 2017, IT WOULD SHOW DATES FOR 5/1/17, 5/2/17, 5/3/17, 5/4/17, 5/5/17, 5/6/17, 5/7/17 AS WELL AS ANYTHING THAT WAS STILL 'PENDING' WITH A DATE OF BEFORE TODAY LIKE 1/1/2011, 5/12/2016
</div>


I AM TRYING TO DISPLAY ALL RECORDS WHERE NEXTDATE IS EITHER PAST DUE OR IN THE CURRENT WEEK.  SO IF IT'S MONDAY MAY 1, 2017, IT WOULD SHOW DATES FOR 5/1/17, 5/2/17, 5/3/17, 5/4/17, 5/5/17, 5/6/17, 5/7/17 AS WELL AS ANYTHING THAT WAS STILL 'PENDING' WITH A DATE OF BEFORE TODAY LIKE 1/1/2011, 5/12/2016

<div>
<div class="content wysiwyg-content">
I'd like to show dates in SQL between PAST DUE and the Current Week. &nbsp;Can someone tell me the correct syntax for that? &nbsp;<br />
<br />
Where (Status = 'pending') AND (NextDate ???????????????
</div>
</div>


I'd like to show dates in SQL between PAST DUE and the Current Week.  Can someone tell me the correct syntax for that?  

Where (Status = 'pending') AND (NextDate ???????????????

SQL DATE Past due to current wek

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.