Find a Range
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.
How to Find a Range of Information
A range is different based on the data type:
-
Numbers: least to greatest
-
Dates, times, and timestamps: earliest to latest
-
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
-
Start a find request.
-
Refer to the following table for examples of different ways to search for a range of information.
To find values that are |
Use this operator |
Examples |
Less than a specified value |
< |
<40 |
Less than or equal to a specified value |
<= or ≤ |
<=95129 |
Greater than a specified value |
> |
>95129 |
Greater than or equal to a specified value |
>= or ≥ |
>=100 |
Within the range you specify |
.. or … |
12:30…17:30 |
Within the sub-range you specify |
{..} or {…} |
7/{1…15}/2010 |
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/*/2010 |
-
When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests > Perform Find.
Notes on Ranges
-
When searching for ranges of information in date, time, and time stamp fields, you don’t have to specify all date or time components.
For example, you can type 5/2019 instead of 5/1/2019…5/31/2019 to find all dates in May 2018. -
You can combine operators to simplify range searches. For example, type */{10..15}/2010 to search for all dates in 2010, but only for days from the 10th through the 15th.
-
Refer to the following tables for examples of different ways to search for dates, times, and timestamps.
Examples of searching for Dates, Times, and Timestamps
To find dates |
Type this in the field |
In June 2010 |
6/2010 |
From July 2009 through October 2010 |
7/2009…10/2010 |
That occur on a Friday |
=Friday |
From the 10th through the 16th of October or November 2010 |
{10..11}/{10..16}/2010 |
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, and 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 2007 |
5/2007 7 PM |
That occur on a Monday in 2010 |
=Mon 2010 |
From the 10th through the 16th of November 2010 and from 3:00 PM to less than 6:00 PM |
11/{10..16}/2010 {3..5} PM |
© 2023 Adatasol, Inc.