User manual

88 FileMaker Pro User’s Guide
Specifying formats for time fields
You can control how FileMaker Pro displays time values in fields.
1. In Layout mode, select one or more time fields, or calculation fields with a time result.
2. Click Inspector in the layout bar, then click Data.
3. In the Data Formatting area, click Time .
4. Select the time format you want to use from the Format list, then select additional formats for the time field.
If you want to format the seconds component to display fractional seconds, continue with the next step.
If you don’t want to format the seconds component, skip to step
6.
5. Click Number in the Data Formatting area, then select the formatting options you want.
Only two options affect the display of the seconds component: Fixed number of decimal digits and
Decimal (to the right of Separators). The remaining options have no effect.
6. Press Enter or Tab, or click outside the Inspector to apply the changes.
For more information about specifying formats for time fields, see Help.
Specifying formats for timestamp fields
You can control how FileMaker Pro displays timestamp values in fields. You format a timestamp field by
separately formatting its three components: date, time (excluding the seconds portion), and seconds
(including fractional seconds).
1. In Layout mode, select one or more timestamp fields, or calculation fields with a timestamp result.
2. Click Inspector in the layout bar, then click Data.
3. To format the date component, in the Data Formatting area, click Date , then select the formatting
options you want.
Choose options for
displaying
Japanese times
Choose to display times
as entered, in a
predetermined format, or
in a format you specify