User manual

26 FileMaker Pro User’s Guide
Finding ranges of information
A Boolean number in a
number field or in a
calculation field that
produces a Boolean
result
1 to find True values
0 to find False values
1 finds 1
0 finds 0
A date in a date field or
in a 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/2005 finds
3/3/2005 ,
March 3, 2005 , and
3-3-2005
Today’s date in a date
field or in a calculation
field that produces a date
result
// // finds April 4, 2005
(when the current date is
4/4/2005)
A time in a time field or
in a 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
A timestamp in a
timestamp field or in a
calculation field that
produces a timestamp
result
The date as digits,
separated by a
nonnumeric character,
then the time as digits,
separated by colons, in
the format used when the
file was created (unless
Use System Formats is
chosen)
3/3/2005 12:53:09
PM finds 3/3/2005 12:53:09
PM
Invalid dates, times,
timestamps, or
calculated date or time
results
? ? finds:
Next Tuesday or 2/33/2005
in a date field, or midnight
in a time field
To find Type this in the field Examples
Invalid data (fields
containing no numbers)
in a number field or
calculation field that
produces a numeric
result
? ? finds:
twelve but not 12 or
twelve30
Ranges of information See the next section.
To find values that are
Use this
operator Examples
Less than a specified value < <40
<9/7/2005
<M
Less than or equal to a specified
value
<=
or ≤ (Mac OS)
<=95129
≤05:00:00
<=M
Greater than a specified value > >95129
>9/7/2005
>M
Greater than or equal to a
specified value
>=
or ≥ (Mac OS)
>=100
>=9/7/2005
≥8:00
≥M
Within the range you specify. A
range is different based on the
data type:
1 Numbers: least to greatest
1 Dates and times: earliest to
latest
1 Text: first to last word, based
on the index order of words
(not the sort order)
.. or ...
(two or three
periods)
12:30...17:30
1/1/2005..6/6/2005
A...M
To find Type this in the field Examples