Home > Designing and creating databases > 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.

To define time fields in Table View:

1.	With the database open in Browse mode, click Table View in the layout bar.

2.	Click + in the column heading to add a new field.

3.	Right-click the column heading for the new field.

4.	Choose Field > Field Type > Time from the shortcut menu.

5.	To select options for the field, right-click the column heading for the field, then choose Field > Field Options.

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

Related topics 

Working with data in time fields