Functions Reference

FILEMAKER FUNCTIONS REFERENCE 87
Related topics
Contents
Functions reference (alphabetical list)
Get(CurrentHostTimestamp)
Purpose
Returns the host’s current date and time (to the nearest second) according to the system clock.
Format
Get(CurrentHostTimestamp)
Parameters
None
Data type returned
timestamp
Originated in
FileMaker Pro 7.0
Description
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.
• For information on how functions evaluate differently on the host versus the client,
search the FileMaker Knowledge Base available at
www.filemaker.com/kb.
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.
Examples
Returns 1/1/2010 11:30:01 AM when the system clock shows January 1, 2010 11:30:01 AM on the
host machine.