<div>
<div class="content wysiwyg-content">
I have the following case statement in a query however it is bringing back the incorrect values, &nbsp;everything is showing up in the result set as 'Greater than 61 days' however there is a range of dates that should be falling into the various categories.<br />
<br />
<br />
&nbsp; case (when &nbsp;trunc(creation_date) &nbsp;between trunc(sysdate) and trunc(sysdate - 7) then '7 Days'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; when &nbsp;trunc(creation_date) between trunc(sysdate -8) and trunc(sysdate -31) then '8-30 Days'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; when &nbsp;trunc(creation_date) &nbsp;between trunc(sysdate -32) and trunc(sysdate -61) then '30 - 60 Days'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else 'Greater 61 Days') end as Aging 
</div>
</div>


I have the following case statement in a query however it is bringing back the incorrect values,  everything is showing up in the result set as 'Greater than 61 days' however there is a range of dates that should be falling into the various categories.


  case (when  trunc(creation_date)  between trunc(sysdate) and trunc(sysdate - 7) then '7 Days'
              when  trunc(creation_date) between trunc(sysdate -8) and trunc(sysdate -31) then '8-30 Days'
              when  trunc(creation_date)  between trunc(sysdate -32) and trunc(sysdate -61) then '30 - 60 Days'
              else 'Greater 61 Days') end as Aging 

Case statement using dates

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.