Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

GetAsText(data)

data - any number, date, time or timestamp 

, or a 

 containing a number, 

date, time, timestamp, or container.

text

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 

container contains text that does not resolve into a valid path), or a question mark (?) if 
the container data is embedded in the database.

GetAsText(45) returns 

.

“You are “ & GetAsText(DaysDelinquent) & “ days late.” returns 

 when the value of DaysDelinquent is 3.

“FY” & GetAsText(FiscalYear) returns 

, if the FiscalYear number field 

contains 98.

GetAsTime(text)

text - any 

 containing a time

time