GetAsText function

Contents > Functions reference (alphabetical list) > Text functions > GetAsText function

GetAsText function

Format


GetAsText(data)

Parameter

data - any number, date, time or timestamp expression, or a field containing a number, date, time, timestamp, or container.

Data type returned

text

Description

Returns data as data type text, for use with formulas involving text or text functions. data can be data type number, date, time, timestamp, or container.

For a container field, GetAsText returns external path information, text (when the container contains text that does not resolve into a valid path), or a question mark (?) if the container data is embedded in the database.

Examples

GetAsText(45) returns 45.

"You are " & GetAsText(DaysDelinquent) & " days late." returns You are 3 days late. when the value of DaysDelinquent is 3.

"FY" & GetAsText(FiscalYear) returns FY98, if the FiscalYear number field contains 98.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Text functions > GetAsText function