Async SOQL doesn't support date literals. code example
Example 1: soql more than today
SELECT Date__c FROM Object__c
WHERE Date__c < TODAY
ORDER BY Date__c DESC
LIMIT 1
Example 2: soql last year
delete [SELECT Id FROM Opportunity WHERE CreatedDate = LAST_YEAR];