<div>
Let's see. CURRENT DATE - day(current date) days &nbsp;will always return the last day of the previous month. If you wanted to return the FIRST day of the previouos month, you could do:<br />
<br />
CURRENT DATE - day(current date) days + 1 day - 1 month<br />
<br />
HTH,<br />
DaveSlash
</div>


Let's see. CURRENT DATE - day(current date) days  will always return the last day of the previous month. If you wanted to return the FIRST day of the previouos month, you could do:

CURRENT DATE - day(current date) days + 1 day - 1 month

HTH,
DaveSlash

<div>
If you wanted to return the first day of the current month, you'd do this:<br />
<br />
CURRENT DATE - day(current date) days + 1 day
</div>


If you wanted to return the first day of the current month, you'd do this:

CURRENT DATE - day(current date) days + 1 day

<div>
@ sathyaram_s, You are correct, that's exactly what I want.<br />
I've changed my code and will see what happens on 4/1.<br />
Thanks
</div>


@ sathyaram_s, You are correct, that's exactly what I want.
I've changed my code and will see what happens on 4/1.
Thanks

<div>
<div class="content wysiwyg-content">
How do I use the CURRENT_DATE function in DB2 to pull data for the entire past month on the first day of a new month?<br />
This job runs flawlessly daily with the piece of code below, but on the 1st of the month it returns no results: <br />
ACCT_OPEN_DT &gt;(CURRENT DATE - day(current date) days ) <br />
<br />
*What do I need to modify to make sure that on the 1st of each month, it still shows the prior month's entire data?<br />
Thanks
</div>
</div>


How do I use the CURRENT_DATE function in DB2 to pull data for the entire past month on the first day of a new month?
This job runs flawlessly daily with the piece of code below, but on the 1st of the month it returns no results: 
ACCT_OPEN_DT >(CURRENT DATE - day(current date) days ) 

*What do I need to modify to make sure that on the 1st of each month, it still shows the prior month's entire data?
Thanks

CURRENT_DATE function to show prior month data

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.