Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Product codes
TJ083LL/A
Page of 238
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
 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 
 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 
 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 
 containing numbers