Filter with date literals
SOQL date literals (TODAY, NEXT_N_DAYS:30, LAST_N_DAYS:30) are evaluated at query time in the user's time zone.
Your task
Count four tagged Opportunities by close date and created date, using SOQL date literals.
String tag = 'AS-Q314-' + UserInfo.getUserId() + '-' +
String.valueOf(Datetime.now().getTime());
String stageName = Opportunity.StageName.getDescribe().getPicklistValues()[0].getValue();
List<Opportunity> seeded = new List<Opportunity>();
for (Integer offset : new List<Integer>{ -45, -5, 10, 45 }) {
seeded.add(new Opportunity(Name = tag + '-' + offset, StageName = stageName,
CloseDate = Date.today().addDays(offset)));
}
insert seeded;
String tagPattern = tag + '-%';Requirements
- NEXT_N_DAYS:30 and LAST_N_DAYS:30 should be present
- CloseDate < TODAY and CreatedDate = TODAY should be present
Name LIKE :tagPatternshould be present in each WHERE- Printed line should be built from runtime values
Next 30 days:should be1Past due:should be2Last 30 days:should be1Created today:should be4