Filemaker Pro 8.5 Retail 5-pack Educational TH330Z/A User Manual
Product codes
TH330Z/A
168 FileMaker Functions Reference
</StyleList>
<Data>
<Span style=”0”>Frank</Span>
</Data>
<Data>
<Span style=”0”>Frank</Span>
</Data>
GetAsText
Format
GetAsText(data)
Parameter
data - any number, date, time or timestamp
, or a
containing a number,
date, time, timestamp, or container.
Data type returned
text
Description
Returns data as data type text, for use with
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
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.
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
containing a time
Data type returned
time