User manual

Creating databases 57
Specifying formats for date fields
You can control how FileMaker Pro displays the values in date fields,
and calculation fields with date results.
Note To avoid confusion when using dates in fields, FileMaker
recommends that you always format date fields to display four-digit
years.
1. In Layout mode, select one or more date fields or calculation fields
with a date result.
2. Choose Format menu > Date.
3. In the Date Format dialog box, select the formats you want to use.
You see examples of the options you choose in the Sample area.
4. Click OK.
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. Choose Format menu > Time.
3. In the Time Format dialog box, select the formats you want to use.
You see examples of the options you choose in the Sample area.
4. Click OK.
If you want to format the seconds component to display fractional
seconds, continue with the next step.
5. Choose Format menu > Number.
6. In the Number Format dialog box, select the formats you want to
use.
Only two options affect the display of the seconds component: Fixed
number of decimal digits
and Decimal separator. The remaining options
have no effect.
7. Click OK.
8. Click OK.
Set font, style, size,
color, line spacing,
and alignment
Choose
options for
day, month,
date, year,
and
separator
characters
Choose to display
numbers either as
entered, in a
predetermined
format, or in a
format you specify
Choose options for
displaying
Japanese dates
Set font, style, size, color,
line spacing, and alignment
Choose to display times
either as entered, in a
predetermined format, or
in a format you specify
Choose options for
displaying Japanese times