Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 7

  

|

  Get functions     77

timestamp

Returns the 

 current date and time according to the system clock, to the nearest 

second.
The format of the value returned is determined by the 

 system’s settings by editing the Regional Settings Control Panel (Windows 

2000), the Date and Time Control Panel (Windows XP), or the Date & Time System 
Preference (Mac OS).

•

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 

 in client/server and 

peer-to-peer environments.

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.

Returns 

 when the system clock shows January 1, 2004 11:30:01 

AM on the host machine.

Get(CurrentTime)

None

time