Get(CurrentHostTimestamp) function

Contents > Functions reference (alphabetical list) > Get functions > Get(CurrentHostTimestamp) function

Get(CurrentHostTimestamp) function

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 Solving calculations on a host machine 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.

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(CurrentHostTimestamp) function