GetAsText
 
Purpose 
Returns data as field type text.
Format 
GetAsText(data)
Parameters 
data - any number, date, time or timestamp expression, or a field containing a number, date, time, timestamp, or container
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Use with formulas involving text or text functions. The data returned can be a field 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. For container data stored externally, data is returned in the format shown in the following example:
GetAsText(Container)returns
remote:cat.jpg
size:320,240
JPEG:Images/Animals/cat.jpg
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
Was this topic helpful? Send feedback.