SOQL query WHERE Date = 30_days_ago?

Question

How do I make a SOQL query like this?

SELECT id FROM Account WHERE LastActivityDate = 30_DAYS_AGO

This produces an error:

MALFORMED_QUERY: 
Account WHERE LastActivityDate = 30_DAYS_AGO
                      ^

Answer 1

SELECT id FROM Account WHERE LastActivityDate = LAST_N_DAYS:30