TOSTRING

Syntax

TOSTRING (expression)

Description

Converts numeric or string (1) data to a string value.

Arguments

expression

The number or string value to convert. expression can be:

— Boolean
— Byte
— DateTime
— Decimal
— Double (any)
— String (1)
— Unsigned Integer (any)

Returns

A String value.

Remarks

If you use a Null string as an argument, TOSTRING returns an empty string.

Example

If the record in MyEntity,CreatedOn was created on April 1, 2011 at 11:30 AM:

TOSTRING (MyEntity.CreatedOn)

Returns: 4/1/2011 11:30:00 AM as a string, which allows you to write the date with the proper format to a string field.