User manual

Chapter 3 | Creating databases 97
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.
Note To format times using the current system format for times, for Format, choose Short
system time or Long system time.
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.
Choose options for
displaying
Japanese times
Choose to display times as
entered, in a
predetermined format, or in
a format you specify