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

166 FileMaker Functions Reference

Example

GetAsCSS(text) returns the example result shown below when the field text contains

the word “Frank” and the word Frank has the following text attributes: Font = Helvetica,

Font Size = 12 points, Font Color = red, Font Style = bold.

Example result:

<SPAN STYLE = “font-family: ‘Helvetica’;font-size: 12px;color:

#FF0000;font-weight: bold;text-align: left;”>Frank</SPAN>

GetAsDate

Format

GetAsDate(text)

Parameter

text - any text expression or text field containing text in the same format as the date on

the system where the file was created.

Data type returned

date

Description

Returns dates in text as data type date, for use in formulas involving dates or date

functions. The format of text date must be the same as the date format on the system

where the file was created.

Use the GetAsDate or Date function to enter a date constant into a formula.

Note If the function returns a number instead of a date, go to the Specify Calculation dialog

box and make sure the Calculation result is date.

Important To avoid errors when using dates, always use four-digit years. For more

information about how FileMaker Pro handles two-digit dates, see FileMaker Pro help.

Example

GetAsDate(“03/03/2005”) returns 3/3/2005. You can perform date operations on

this result.

GetAsNumber

Format

GetAsNumber(text)

Parameter

text - any text expression or text field containing numbers

1 2 ... 161 162 163 164 165 166 167 168 169 170 171 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 166