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

  1. Start a find request.

  2. 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
<9/7/2010
<M

Less than or equal to a specified value

<= or ≤

<=95129
≤05:00:00
<=M

Greater than a specified value

>

>95129
>9/7/2010
>M

Greater than or equal to a specified value

>= or ≥

>=100
>=9/7/2010
≥8:00
≥M

Within the range you specify

.. or …
(two or three periods)

12:30…17:30
1/1/2009..6/6/2010
A…M
Mon..Fri

Within the sub-range you specify

{..} or {…}
(two or three periods)

7/{1…15}/2010
{1..3}/{10..16}/2010
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/*/2010
2/*
2010 *:30 PM

 

  1. 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.