Functions Reference

Table Of Contents
76 FileMaker Functions Reference
Note See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Example
Returns 5 when FileMaker Pro is calculating the fifth repetition of a repeating field.
Get(CurrentDate)
Format
Get(CurrentDate)
Parameter
None
Data type returned
date
Description
Returns the current date according to the system calendar.
The format of the result varies based on the date format that was in use when the
database file was created. In the United States, dates are generally in the format MM/DD/
YYYY. You can change the date format in the Regional Settings Control Panel (Windows
2000), the Date and Time Control Panel (Windows XP), or the Date & Time System
Preference (Mac OS).
If the result is displayed in a field, it is formatted according to the date format of the field
in the current layout.
Note See FileMaker Pro help for information about running scripts
in client/server and
peer-to-peer environments.
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
Returns 2/2/2004 when the system date is set to February 2, 2004.
Get(CurrentHostTimestamp)
Format
Get(CurrentHostTimestamp)
Parameter
None