soql query to pull last n days code example Example: soql last week Select * from case where WHERE CreatedDate = LAST_N_DAYS:30