Functions Reference

Chapter 7
|
Get functions 71
Get(CurrentHostTimestamp)
Format
Get(CurrentHostTimestamp)
Parameter
None
Data type returned
timestamp
Description
Returns the host’s current date and time according to the system clock, to the nearest
second.
The format of the value returned is determined by the database file’s settings. You can
use your client system’s settings in the operating system.
Notes
• The client machine and host machine may be in different times zones so
Get(CurrentHostTimestamp) and Get(CurrentTimestamp) may return
different date/time values. Also, the current date and time are characteristics of the
host system, but the format of the date and time is a characteristic of the database
file.
• See FileMaker Pro Help for information about running scripts in client/server and
peer-to-peer environments.
Important For users who are connected over a network, the
Get(CurrentHostTimestamp) function can affect the performance of the database
file. For example, if you use the function in an unstored calculation field, and the field is
visible in a list view, each display of the field requires an additional network access. Stored
calculation fields are a better use of the function. For example, if you automatically enter
a timestamp for each newly created record using a stored calculation field, you minimize
network access.
Example
Returns 1/1/2008 11:30:01 AM when the system clock shows January 1, 2008 11:30:01
AM on the host machine.