Functions Reference

160 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/2009”) returns 3/3/2009. You can perform date operations on
this result.