ToString

The ToString() function converts a value to text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Note: this function uses the language setting of a portal when converting a value.

Returns a text representation of value.

This will make an unknownstring a known-string with empty value!

IsUnknown(ToString(unknownstring)) will return false and IsEmpty(ToString(unknownstring)) will return true.

Syntax

ToString(value)

ToString(Date(2016, 12, 31, 15, 45)) => "zaterdag 31 december 2016 15:45" {according to Dutch language}

ToString(unknownstring) => empty string ("")

ToString(765432123456.78901, "#,##0.00") => "765432123456.78901"

ToString('World regions'.'EMEA') => "EMEA"

Parameters

Name	Type	Required	Description
value		☑️	a value of any type.
format	text		a text with the format to which value must be converted. This parameter only applies when converting a datetime, duration or number.