where o.createdate >= dateadd(year, -1, current_date)