Filemaker TH325Z/A Fiche technique télécharger pdf (Page 168)

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

1 2 ... 163 164 165 166 167 168 169 170 171 172 173 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 168