Finding records > Finding ranges of information
 
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.
 
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 FileMaker 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
Related topics 
Finding text and characters
Finding numbers, dates, times, and timestamps
Was this topic helpful? Send feedback.