Functions Reference

168 FileMaker Functions Reference
</StyleList>
<Data>
<Span style=”0”>Frank</Span>
</Data>
GetAsText
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.
GetAsTime
Format
GetAsTime(text)
Parameter
text - any text expression
or text field containing a time
Data type returned
time