Get(CurrentDate)
 
Purpose 
Returns the current date according to the system calendar.
Format 
Get(CurrentDate)
Parameters 
None
Data type returned 
date
Originated in 
FileMaker Pro 6.0 or earlier
Description 
The format of the result of this function 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  For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
Important  To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years.
Examples 
Returns 2/2/2014 when the system date is set to February 2, 2014.
Get(CurrentDate)-Date(1;5;2014) returns 4 when the system date is set to January 9, 2014.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.