About timestamp fields
Use timestamp fields to store a date and time together to reference a fixed point in calendar time.
A timestamp field can store date values from January 1, 0001 to December 31, 4000. Timestamps are measured in seconds.
Important  To avoid confusion when using dates in FileMaker Pro, always use four-digit years. For information on how FileMaker Pro handles dates with two-digit years, see Conversion of dates with two-digit years.
Notes
 •
 •
 •
 •
 •
 •
When you select Insert menu > Current Time in an active timestamp field, FileMaker Pro inserts the full current date and time.
 •
When you select Insert menu > Current Date in an active timestamp field, FileMaker Pro inserts the current date only.
 •
 •
Related topics 
About defining database fields
Working with data in date fields
Working with data in time fields
Dates are not as expected