---
schema_version: "1"
id: db6d8d45bdb272331e338825365797538aed0cfc1e40cb07a76c6dbca8701b15
title: FORMAT()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-sosl-format.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-sosl-format.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 41a8fba476c1c3fc10e34f1c80d1557a512a77a9889d970eac37a06164bb42a7
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# FORMAT()

Use `FORMAT` with the `FIND` clause to apply localized formatting to standard and custom number, date, time, and currency fields.

When the `FORMAT` function is applied these fields reflect the appropriate format for the given user locale. The field format matches what appears in the Salesforce Classic user interface. For example, the date _December 28, 2015_ can appear numerically as _2015-12-28_, _28-12-2015_, _28/12/2015_, _12/28/2015_, or _28.12.2015_, depending on the org’s locale setting.

The `FORMAT` function supports aliasing. In addition, aliasing is required when the query includes the same field multiple times. For example:

```nolang
FIND {Acme} RETURNING Account(Id, LastModifiedDate, FORMAT(LastModifiedDate) FormattedDate)
```

You can also nest it with aggregate or `convertCurrency()` functions.

```nolang
FIND {Acme} RETURNING Account(AnnualRevenue, FORMAT(convertCurrency(AnnualRevenue)) convertedCurrency)
```