FORMULA LANGUAGE


Converting data types
Example

Data must be the correct type for the operation involved. The following @functions convert data, and test for type.

FunctionDescription
@Char(number)Converts an IBM® Code Page 850 code number to its corresponding character.
@IsNumber(value)Returns True (1) if a value is a number or number list.
@IsText(value)Returns True (1) if a value is a text string or text string list.
@IsTime(value)Returns True (1) if a value is a time-date or time-date list.
@Text(value)Converts a value to a text string.
@Text(value ; format)Converts a numeric or date-time value to a text string according to a specified format.
@TextToNumber(string)Converts a text string to a number.
@TextToTime(string)Converts a text string to a date-time value.
@TimeToTextInZone(date-time ; time zone)Converts a date-time value to a string that includes time zone information.
@TimeZoneToText( time zone)Converts a time zone value to a human-readable string.
@ToNumber(string or value)Converts a number or text string to a number.
@ToTime(string or date-time value)Converts a number or date-time value to a date-time value.

Example
See Also