Defining time fields

Contents > Creating a database > Defining database fields > Defining time fields

Defining time fields

Use time fields to store:

times you need to sort or search through

times used in calculation formulas or summary fields

To define time fields:

1.	With the database open, choose File menu > Manage > Database.

2.	In the Manage Database dialog box, click the Fields tab.

3.	If your database contains more than one table, select the appropriate table from the Table list.

4.	For Field Name, type a name for the field.

See About naming fields.

5.	For Type, select Time.

6.	Click Create.

7.	To select options for the field, click Options.

See Setting options for fields.

8.	Continue to define fields or click OK.

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. To change the display format for a field (for example, 11:09 PM or 23:09), set options in the Time Format dialog box in Layout mode. See Specifying formats for time fields.

To specify how data in a time field displays (for example, to specify whether the time is displayed in 12 hour or 24 hour format or shows "AM" and "PM"), see Formatting and setting up field objects in Layout mode.

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. For more information, see Copying and pasting field schemas (FileMaker Pro Advanced).

Related topic

Working with data in time fields

Contents > Creating a database > Defining database fields > Defining time fields