Views:

Description

Returns a string representation of any number, decimal, currency or boolean value. An optional format and Locale ID may also be applied. Google 'MSDN ToString Formatting' for further details.

Signature

ToString('valuetoconvert', 'format', 'LCID')

Format and LCID are optional.

Example 1

ToString(99) Returns '99'

Example 2

ToString(LocalDate(), 'MMM-yyyy') Returns 'DEC-2011'

Example 3

ToString(LocalDate(), 'd', '1033') Returns '12/25/2011'

Example 4

ToString(LocalDate(), 'd', '1031') Returns '25.12.2011'