Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Get functions > Get(CurrentDate) function |
|
|
| Get(CurrentDate) function |
| 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 Solving calculations on a host machine 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 Conversion of dates with two-digit years. |
| Example |
| Returns 2/2/2008 when the system date is set to February 2, 2008. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Get functions > Get(CurrentDate) function |
|
|
Next Page |
|