User manual

28 FileMaker Pro User’s Guide
Finding ranges of information
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 dates Type this in the field
In June, 2005
6/2005
From July 1997 through October 1998
7/1997...10/1998
That occur on a Friday
=Friday
From the 10th through the 16th of
October or November, 2006 (if the
date format is MM/DD/YYYY)
{10..11}/{10..16}/2006
That occur on March 1st between 1868
and 1912 in the Japanese Emperor
Year era of Meiji
m*/3/1
That occur on December 31st between
1930 and 1940 in the Japanese
Emperor Year era of Showa
S{5..15}+12+31
To find times Type this in the field
In the 3 o’clock hour, not including
4:00 PM
3 PM
Between 8:00 AM and 8:59:59 PM
8 AM..8 PM
In the morning
AM
Any of the times 4:30, 5:30, 6:30 PM
{4..6}:30 PM
To find timestamps Type this in the field
In the 3 o’clock hour today
// 3 PM
In the 7 o’clock hour in May, 2005
5/2005 7 PM
That occur on a Monday in 2006
=Mon 2006
From the 10th through the 16th of
November, 2006 and from 3:00 PM to
less than 6:00 PM (if the date format is
MM/DD/YYYY)
11/{10..16}/2006 {3..5} PM
To find dates Type this in the field