Format

Description

Formats the value using a specified format string parameter type identifier and parameter value of the specified type. This function is limited to one value parameter.

Syntax

Format(Format:String,ParamType:String, ValueToFormat:String):String

Format is the format to apply.

ParamType is the data type to use for comparing values. Valid values: string, integer, float, date. The default value is integer.

ValueToFormat is the value on which to perform the function.

Example

Format('%8.2f',Float,123.456)

Return value is 123.46.