(Object Object)
Returns the text representation of the object.
Example: ToString(123) return string representation of the number (123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported
(Object Object, string Pattern)
Returns the text representation of the object.
Example: ToString(123, '0###') return string representation of the number (0123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported
(Object Object, string Pattern, string cultureCode)
Returns the text representation of the object.
Example: ToString(123, '0###', 'en-US') return string representation of the number (0123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported
Example 1
The CONCATENATE function operates on strings only. TOSTRING is used to convert from integer to string:
concatenate(left(tostring(&CPR),6),"-",right(tostring(&CPR),4))
Example 2
Month names in German:
tostring(&Date,"MMMM","de-DE")
Locale ID examples:
- Danish = da-DK
- German = de-DE
- Dutch = nl-NL
- English US = en-US
- French = fr-FR
Full Locale ID list: Locale ID reference
Comments
Please sign in to leave a comment.