Expressions.expr-primary-format

Use FORMATVALUE to return a string that is formatted according to the instructions that are contained in a format String expression.

Format

FORMATVALUE( Value USING Format )

Remarks

The Value is formatted using the format that is specified by the Format argument, and returns the result as a String. The Value argument can be any type of expression. The Format argument can be any character string expression.

For a description of the options allowed in the Format argument, see Define a Custom Value Format.

Example:

FORMATVALUE( 12.5 USING '#0.0000' ) returns '12.5000'

FORMATVALUE( DATE '2025-08-02' USING 'EEEE, MMMM d, yyyy' ) returns 'Wednesday, August 2, 2025'

FORMATVALUE( 1000000 USING '#,###' ) returns '1,000,000'

FORMATVALUE( 1000000 USING '0E0' ) return '1E6'