Finding ranges of information
You can find ranges of information, such as all records that contain a field value that is greater or less than a number, or between two particular dates. A range is different based on the data type:
 •
Numbers: least to greatest
 •
 •
Text: first to last word, based on the index order of words (not the sort order). A word can be a single character; for example, a find on a field for <M would return every record that contains a word less than M in the field’s index order.
To find ranges of information:
1.
For more information, see Making a find request.
2.
 
<40
<9/7/2014
<M
<=95129
05:00:00
<=M
>95129
>9/7/2014
>M
>=100
>=9/7/2014
8:00
M
.. or ...
(two or three periods)
12:30...17:30
1/1/2014..6/6/2015
A...M
Mon..Fri
{..} or {...}
(two or three periods)
7/{1...15}/2014
{1..3}/{10..16}/2015
12:{30..45}
{7...9}:15 PM
Based only on certain date or time components such as month, year, or minutes (see more examples below)
* or type nothing for each component you don’t want to specify
3/*/2014
2/*
2014 *:30 PM
3.
When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
Notes
 •
When searching for ranges of information in date, time, and timestamp fields, you don’t have to specify all date or time components. For example, you can type 5/2014 instead of 5/1/2014...5/31/2014 to find all dates in May 2014.
 •
You can combine operators to simplify range searches. For example, type */{10..15}/2014 to search for all dates in 2014, but only for days from the 10th through the 15th.
 •
 •
 
That occur on March 1st between 1868 and 1912 in the Japanese Emperor Year era of Meiji
That occur on December 31st between 1930 and 1940 in the Japanese Emperor Year era of Showa
 
 
From the 10th through the 16th of November 2015 and from 3:00 PM to less than 6:00 PM
Related topics 
Finding text and characters
Finding numbers, dates, times, and timestamps