FileMaker Command - Get(CurrentHostTimestamp)


Igeek take a look at this FileMaker database command.

Get(CurrentHostTimestamp)
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 version 
7.0

Description 
The data type of a calculation result determines how the returned value of this function is represented.

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.

•In FileMaker Cloud products, this function returns the date and time in Coordinated Universal Time (UTC). If you want the date and time in the host’s local time zone, you must adjust the value returned by this function by the difference between UTC and the host’s time zone.

igeek are based in Weston-super-Mare and develop Claris / FileMaker database software for clients in Bristol and the South West of England.


Blog entry is closed for new comments.