User manual

Chapter 2 | Using databases 36
Finding ranges of information
To find values that are Use this operator Examples
Less than a specified value < <40
<9/7/2014
<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/2014
>M
Greater than or equal to a specified value >=
or ≥ (Mac OS)
>=100
>=9/7/2014
≥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/2014..6/6/201
5
A...M
To find dates Type this in the field
In June 2014 6/2014
From July 2014 through October 2015 7/2014...10/2015
That occur on a Friday =Friday
From the 10th through the 16th of October or November 2014
(if the date format is MM/DD/YYYY)
{10..11}/{10..16}/2014
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 2014 5/2014 7 PM