day before yesterday in soql query code example
Example 1: string literal soql date format
//Date only:
YYYY-MM-DD 1999-01-01
//Date, time, and time zone offset: YYYY-MM-DDThh:mm:ss+hh:mm
YYYY-MM-DDThh:mm:ss-hh:mm
YYYY-MM-DDThh:mm:ssZ
1999-01-01T23:01:01+01:00
1999-01-01T23:01:01-08:00
1999-01-01T23:01:01Z
Example 2: soql last year
delete [SELECT Id FROM Opportunity WHERE CreatedDate = LAST_YEAR];