Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 113
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar,
or choose Requests menu
> Perform Find.
Notes
• When you enter numbers, dates, days of the week, times, and timestamps into find
requests, always enter them using the appropriate system or file settings that are in use.
• When you perform day of the week searches on systems set to a language other than
English, you may use English day names and abbreviations if you wish. The English names
are supported in all
system formats. See Opening files with different system formats.
• When you perform day of the week searches, the first day of the week depends on your
system settings. Sunday is the first day of the week in English, Japanese, and Korean, but
Monday is the first day of the week in German, French, Italian, Swedish, Dutch, Spanish,
and other system formats that FileMaker
Pro supports.
Related topics
About number fields
About date fields
About time fields
Today's date in a date field
or in a calculation field that
produces a date result
// // finds April 4, 2014 (when the
current date is 4/4/2014)
A time in a time field or in
a calculation field that
produces a time result
The time as digits, separated by
colons
12:53:09 finds 12:53:09
A timestamp in a
timestamp field or in a
calculation field that
produces a timestamp
The date as digits, separated by a
valid date separator character, then
the time as digits, separated by
colons
3/3/2014 12:59:09 PM
finds 3/3/2014 12:59:09 PM
Invalid dates, times,
timestamps, or calculated
date or time results
? ? finds Next Tuesday or 2/33/
2014 in a date field, or midnight
in a time field
Dates on a day of the
week in a date or
timestamp field
The day of the week
Note Full or short day names (for
example, Friday or Fri) are
acceptable in day of week searches
Tuesday finds all dates that
occur on a Tuesday
=Thu finds all dates that occur
on a Thursday
Any valid value for a date
or time component in a
date, time, or timestamp
field
* or leave component unspecified,
while specifying the other
components you want to find
5/12/* finds the 12th day of
May in any year
5/12 finds the 12th day of May
in the current year
*:15 finds times 15 minutes
after any hour
1/1/* 7 PM finds timestamps
in the 7 o’clock PM hour on
January 1st in any year
Ranges of information See Finding ranges of information
To find Type this in the field Examples