Is there a simple way to return the last day of the year 2 or 3 years ago? I have a huge payroll table, and I'd like to only return records for the past 2 years (or sometimes 3). I don't want to specify any dates in my query, I just want it to get anything after date X where X is December 31, CURRENTYEAR-2 or where X is December 31, CURRENTYEAR-3 There appear to be a lot of ways to do this, I want to use the simplest. Every time I try to write this, my code gets longer and more convoluted. My latest try was this, but I don't like hard coding a number of months: Code (Text): SELECT LAST_DAY(ADD_MONTHS(LAST_DAY(TRUNC(SysDate,'YEAR')), -13)) "Two Years Ago First Day" FROM Dual Thanx!