Finding ranges of information

A range of information differs according to 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.

    See Making a find request.

    2. To find values that are

    Use this operator

    Examples

    Less than a specified value

    <

    <40
    <9/7/2019
    <M

    Less than or equal to a specified value

    <= or ≤

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

    Greater than a specified value

    >

    >95129
    >9/7/2019
    >M

    Greater than or equal to a specified value

    >= or ≥

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

    Within the range you specify

    .. or ...
    (two or three periods)

    12:30...17:30
    1/1/2019..6/6/2020
    A...M
    Mon..Fri

    Within the sub-range you specify

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

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

  2. Click Perform Find in the status toolbar.

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/2019 instead of 5/1/2019...5/31/2019 to find all dates in May 2019.
  • You can combine operators to simplify range searches. For example, type */{10..15}/2019 to search for all dates in 2019, but only for days from the 10th through the 15th.
  • For information on writing scripts to find a range of dates, search the Knowledge Base.
  • Refer to the following tables for examples of different ways to search for dates, times, and timestamps.

    • To find dates

    Type this in the field

    In June 2019

    6/2019

    From July 2019 through October 2020

    7/2019...10/2020

    That occur on a Friday

    =Friday

    From the 10th through the 16th of October or November 2019

    {10..11}/{10..16}/2019

    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 2019

    5/2019 7 PM

    That occur on a Monday in 2020

    =Mon 2020

    From the 10th through the 16th of November 2020 and from 3:00 PM to less than 6:00 PM

    11/{10..16}/2020 {3..5} PM