FileMaker Command - Get(CurrentHostTimestamp)

Igeek take a look at this FileMaker database command.

Returns the host's current date and time (to the nearest second) according to the system clock.

Get ( CurrentHostTimestamp )


Data type returned 

Originated in version 

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

•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.