How to query last one year records?

Question

I am trying to delete records from last one year created records using a batch class. How can I query record whose CreatedDate spans from the current date to last one year?

Answer 1

You can use Date Literals:

For deleting records of last year:

delete [SELECT Id FROM Opportunity WHERE CreatedDate = LAST_YEAR];

For all records not created this year:

delete [SELECT Id FROM Opportunity WHERE CreatedDate != THIS_YEAR];

With this, you do not have to worry about manipulating with date/year separately.

Answer 2

Integer year = Date.today().year() - 1;
Date todaysDate = Date.today();
List<Contact> contactList= [SELECT id FROM Contact WHERE CALENDAR_YEAR(CreatedDate) =: year AND DAY_ONLY(CreatedDate) =: todaysDate];

refer these date time functions and mold the SOQL query as per your requirment.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm

Answer 3

You can also tray a much yeasier way to do it

Date todaysDate = Date.today();
Date lastYearDate = Date.today() - 365;
        
List <Account> accts = [SELECT Id, CreatedDate__c
                        FROM Account 
                        WHERE CreatedDate__c >: lastYearDate AND CreatedDate__c <: todaysDate 
                       ];