Development questions
Write a SOQL query using FORMAT() to return localized formatted dates and currency values for UI display.
FORMAT() returns values formatted for the user's locale (dates, datetimes, numbers, currency), which is handy for display without Apex formatting code.
soql
SELECT Id, FORMAT(CloseDate) closeFmt, FORMAT(Amount) amountFmt, FORMAT(convertCurrency(Amount)) convertedFmt
FROM Opportunity
The formatted values come back as strings, so use them for UI display only and keep the raw values for calculations.
soqlscenarioformat
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?