To get the last day of the year before last -
select add_months(trunc(sysdate,'yy') - 1,-12) from dual;
Can you provide a little more description of what you need given different current dates?
0
MIREESEAuthor Commented:
Thanks This worked!!
Since this is only an issue in January, How could I code this to look back 2 years only during January and only look back 1 year the after January?
Example
If Month = Jan aging date = last month of 2012 else
will return Dec 31 2013
add_months(trunc(sysdate,'
will return Dec 31 2012
you could also use
trunc(trunc(sysdate,'yyyy'
or
trunc(sysdate,'yyyy') - 1 - interval '1' year