Development questions
What are SOQL Date Literals (e.g., TODAY, LAST_N_DAYS:30, THIS_FISCAL_YEAR, NEXT_MONTH) and why are they preferred over hardcoded dates?
Date literals are keywords that represent relative date ranges computed at run time, e.g. TODAY, YESTERDAY, LAST_N_DAYS:30, THIS_MONTH, NEXT_MONTH, THIS_FISCAL_YEAR, LAST_QUARTER.
They are preferred because queries stay valid over time without code changes, respect the user's time zone and the org's fiscal year settings, and avoid date-formatting mistakes.
soql
SELECT Id FROM Opportunity WHERE CloseDate = THIS_FISCAL_QUARTER
SELECT Id FROM Case WHERE CreatedDate = LAST_N_DAYS:30
soqldate-literals
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?