salesforce query fileter by date code example Example: soql last week Select * from case where WHERE CreatedDate = LAST_N_DAYS:30