User manual

Chapter 3 | Creating databases 93
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.
4. To format the time component (except the seconds portion), in the Data Formatting area, click
Time
, then select the formatting options you want.
5. To format the seconds and fractional seconds component, in the Data Formatting area, click
Number
, 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.
Note You must specify formats for both date and time components before any formatting will be
applied. If you select As entered for either Date or Time, then the data in the timestamp field
appears the way it is entered.
For more information about specifying formats for timestamp fields, see Help.
Choose options for
displaying
Japanese times
Choose to display times as
entered, in a
predetermined format, or in
a format you specify