Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 115
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/2014 instead of
5/1/2014...5/31/2014 to find all dates in May 2014.
• You can combine operators to simplify range searches. For example, type */{10..15}/
2014
to search for all dates in 2014, but only for days from the 10th through the 15th.
• For information on writing scripts to find a range of dates, see http://help.filemaker.com.
• Refer to the following tables for examples of different ways to search for dates, times, and
timestamps.
Related topics
Finding text and characters
Finding numbers, dates, times, and timestamps
Finding data in related fields
You can enter find criteria in related fields that are displayed in a portal or directly on a layout.
To find dates Type this in the field
In June 2014 6/2014
From July 2014 through October 2015 7/2014...10/2015
That occur on a Friday =Friday
From the 10th through the 16th of October or
November 2014
{10..11}/{10..16}/2014
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 2014 5/2014 7 PM
That occur on a Monday in 2015 =Mon 2015
From the 10th through the 16th of November
2015 and from 3:00 PM to less than 6:00 PM
11/{10..16}/2015 {3..5} PM