Help

Creating a database
F
ILEMAKER PRO HELP 171
changing the display format for a field (for example, July 7, 2014 or 7/7/2014), see
Specifying formats for date fields.
• New files and clones of existing files use the current operating system format for date
formatting.
• To make sure dates are always entered with four-digit years, see Defining field validation.
• If you are using FileMaker Pro Advanced, you can copy field schemas from one file and
paste them into the same file or some other file. See Copying and pasting field schemas
(FileMaker Pro Advanced).
Related topics
About defining database fields
Specifying formats for date fields
Working with data in date fields
Dates are not as expected
About time fields
Use time fields to store:
• times you need to sort or search through
• times used in calculation formulas or summary fields
Notes
• The separators in time fields and the order in which the time parts appear depend on the
system formats set for the file and the display format for the field. For information on
changing the display format for a field (for example, 11:09 PM or 23:09), see
Specifying
formats for time fields.
• If you are using FileMaker Pro Advanced, you can copy field schemas from one file and
paste them into the same file or some other file. See Copying and pasting field schemas
(FileMaker Pro Advanced).
Related topics
About defining database fields
Working with data in time fields
Specifying formats for time fields
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.