U.M. (Mac OS)

Table Of Contents
3-64 FileMaker Pro User’s Guide
Formatting date values in individual fields
Format dates in date fields, or calculation, summary, or global fields that
have a date result. You can also leave a date unformatted, so it will
display and print as typed. A date field can hold values from
1 January 0001 to 31 December 3000.
1. In Layout mode, select a date field, and then choose Date from the
Format menu.
To format more than one date field at a time, Shift-click each field to
format, and then choose Date from the Format menu.
2. In the Date Format dialog box, select options, and then click OK.
Display of zero values Select Do not display number if zero.
Decimal separator For Decimal separator, double-click the current default, and then
type a new one.
Thousands separator Select Use thousands separator, double-click the current default,
and then type a new one.
Format for negative
numbers
For Format as, choose an option. To display negative numbers in
color, select Use color, and then choose a color.
Choose FileMaker Help Index from the or Help menu, and then type:
E numbers, formatting
To display dates Do this
Exactly as typed or
entered
Click Leave data formatted as entered.
In a particular format Click Format as, and then choose a format. To change the
default separator between parts of numeric dates, for Numeric
separator, type another character.
In a custom format Click Custom, and then choose options and separator characters
for day of week, month, date of month, and year.
With leading zeroes (as
in 01/02/98) or leading
spaces in numeric parts
of dates
Choose options for For day numbers, For month numbers, or both.
With different text
attributes
Click Text Format, and then select options. (See “Formatting
text attributes in individual fields” on page 3-60.)
To change the
default Do this