soql last week
Select * from case where WHERE CreatedDate = LAST_N_DAYS:30
Source: developer.salesforce.com
soql last year
delete [SELECT Id FROM Opportunity WHERE CreatedDate = LAST_YEAR];
Source: salesforce.stackexchange.com