U.M. (Mac OS)

4-24 FileMaker Pro User’s Guide
Finding numbers, dates, and times
Note
For information about system formats, see appendix B, “Working
with international files.”
To find Type this in the field Example
A number in a number field
or calculation field that
produces a numeric result
The number, in the format
used when the file was
created (unless Use System
Formats is chosen)
.50 finds .50, $.50, and 50%
A Boolean number in a
number field or calculation
field that produces a Boolean
result
The value you’re using for
the field
Y, y, t, and T find Yes
1 finds 1
F, f, n, and N find False
A date in a date field or
calculation field that
produces a date result
The date as digits, separated
by a nonnumeric character, in
the format used when the file
was created (unless Use
System Formats is chosen)
3/3/98 finds 3/3/98,
March 3, 1998, and
3/3/1998
Today’s date in a date field or
calculation field that
produces a date result
// // finds April 4, 1998 (when
the current date is
4/4/98)
A time in a time field or
calculation field that
produces a time result
The time as digits, separated
by colons, in the format used
when the file was created
(unless Use System Formats is
chosen)
12:53:09 finds 12:53:09
Choose FileMaker Help Index from the or Help menu, and then type:
E data, finding