Get last modified data older than 30 days from now in SOQL

Question

I wrote the code for the condition: delete data where LastModifiedDate is older than 30days from today.

Code:

data= [SELECT Id, Name, Type, Status, LastModifiedDate FROM Account ];

            for(Account account : data)
                {
                    Integer daysCount = (system.today()).daysBetween(Date.valueOf(account.LastModifiedDate));
                    if(daysCount>30){
                        //Purge data
                        delete account ;
                    }
                }

But should write above logic in the SOQL query itself to get data which is older than 30days from now to delete. I tried with the below SOQL but it gives all records even latest records too.

  data = [SELECT Id, LastModifiedDate FROM Accont where  LastModifiedDate = LAST_N_DAYS: 30];

Answer 1

You can use a filter without needing a variable, via LAST_N_DAYS:

data = [SELECT LastModifiedDate 
        FROM Account 
        WHERE LastModifiedDate < LAST_N_DAYS:30];

This returns records that haven't been modified in 30 days.

Also see Date Formats and Date Literals for other alternatives.

Answer 2

Try this on SOQL and it will work:

SELECT name, Format(LastModifiedDate) FROM Account WHERE LastModifiedDate = LAST_N_DAYS:01