Use functions in SOQL queries to generate reports for analysis, apply localized formatting to standard and custom fields, group or filter data by date periods, and more.
| Functions | Description |
|---|---|
| Aggregate Functions | Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. |
convertCurrency() |
Use convertCurrency() in SOQL queries to convert currency fields to the user’s currency. |
convertTimezone() |
Use convertTimezone() in a date function of SOQL queries to convert dateTime fields to the user’s time zone. |
| Date Functions | Use date functions in SOQL queries to group or filter data by date periods such as day, calendar month, or fiscal year. |
FORMAT() |
Use FORMAT() in SOQL queries to apply localized formatting to standard and custom number, date, time, and currency fields. |
GROUPING(fieldName) |
Use GROUPING(fieldName) in SOQL queries to identify subtotals. |
toLabel() |
Use toLabel() to translate SOQL query results into the language of the user who submits the query. |