Functions Reference

70 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 and time formats in your operating system.
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/2008 when the system date is set to February 2, 2008.