Working with data in time fields

Contents > Adding and viewing data > Entering data in records > Working with data in time fields

Working with data in time fields

When entering data in time fields, type the date in the system format used when the file was created. Type the time of day (or time duration) as one of the following:

hours: 12

hours and minutes: 12:20

hours, minutes, and seconds: 12:20:45

hours, minutes, seconds, and fractional seconds: 12:20:45.89

Notes

If you type a single digit, FileMaker Pro assumes it's the hour (typing 5 in a time field indexes it as 5:00:00).

Type the time of day in 24- or 12-hour format, with or without AM or PM. (AM is assumed for a time less than 12:00).

You can type a negative time duration in a time field, like -08:40:00. You can't type a negative time if Strict data type validation is defined for the field options. See Defining field validation.

For more information on system formats, see Opening files with foreign system formats.

Each time field parameter (hours, minutes, and seconds) can store values up to
2³¹ - 1 (2,147,483,647).

Defining time fields

Specifying formats for time fields

Setting options for fields

Inserting the current date or other variables into a field

Contents > Adding and viewing data > Entering data in records > Working with data in time fields