Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 112
Related topics
Finding duplicate values
Finding ranges of information
Choosing a language for indexing or sorting
Finding numbers, dates, times, and timestamps
When you enter criteria in a find request, numbers, dates, times, and timestamps should be entered
in the corresponding
field types (or calculation fields returning the corresponding field type) to
ensure correct behavior when finding them.
Important Entering two-digit year dates along with Find operators in a find request will be
interpreted as four-digit dates based on a conversion algorithm. For example, entering a find
request as
1/1/14 .. 12/31/15 will find the years 2014 through 2015 if the current year is 2014.
It is strongly recommended that complete four-digit years be used to avoid possible confusion. For
more information about the conversion algorithm, see Conversion of dates with two-digit years.
To find numbers, dates, times, and timestamps:
1. Start a find request.
See Making a find request.
2. Refer to the following table for examples of different ways to search for numbers, dates,
times, and timestamps.
To find Type this in the field Examples
A number in a number
field or in a calculation
field that produces a
numeric result
The number .50 finds .5, .50, and $.50
One or more digits in a
number field or in a
calculation field that
produces a numeric result
A # character for each digit # finds 3 but not 30
## finds 30 but not 3 or 300
#3 finds 53 and 43 but not 3
A Boolean number in a
number field or in a
calculation field that
produces a Boolean result
1 to find True values
0 to find False values
1 finds 1
0 finds 0
Invalid data (fields with no
numeric digits) in a
number field or calculation
field that produces a
numeric result
? ? finds twelve but not 12 or
twelve30
A date in a date field or in
a calculation field that
produces a date result
The date as digits, separated by a
valid date separator character (such
as a slash or hyphen)
Note For help entering dates with
the drop-down calendar, see
Working with data in date fields
3/3/2014 finds 3/3/2014,
March 3, 2014, and 3-3-2014