Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 114
About timestamp fields
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
• 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. Refer to the following table for examples of different ways to search for a range of
information.
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar,
or choose Requests menu
> Perform Find.
To find values that are Use this operator Examples
Less than a specified value < <40
<9/7/2014
<M
Less than or equal to a specified value <= or ≤ <=95129
≤05:00:00
<=M
Greater than a specified value > >95129
>9/7/2014
>M
Greater than or equal to a specified value >= or ≥ >=100
>=9/7/2014
≥8:00
≥M
Within the range you specify .. or ...
(two or three
periods)
12:30...17:30
1/1/2014..6/6/2015
A...M
Mon..Fri
Within the sub-range you specify {..} 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