Thank you, Rick, for your suggestion. Unfortunately I'm not
making progress.
When I enter 1/1/2011...10/3/2011 as a find criterion
Filemaker changes it to
*/1/2011 */1/2011 */*/2011...*/10/2011 */3/2011 */*/2011
and tells me "No records match this find criterion."
My regional OS settings specify a d/m/y date format and
Filemaker recognizes this. However, changing this doesn't
seem to help.
When I look at the discussion around Terry Teitelbaum's post
on "Re: Find Not Working on Some Fields" I have to say that
I also find some of Filemaker's behaviour on Finds quite
inexplicable. In my case I have worked around the problem by
created a calculated field for year and one for month; I can
then search on these. However, one would like to know why
FMP doesn't behave as specified - is it something in the
design of the database, or is there a bug that manifests
itself in certain circumstances or what?
Bruce
On 12/5/2011 02:36 AM, Rick O'Quinn wrote:
Bruce,
You need to use three periods (...) to search date ranges. So to find
everything up to April 14, your search string would be ...4/14/11. Same with a
between range, like 4/2...4/10/11. Pretty cool now too, you can search the
month of May just by 5/2011, ranges 3/2011...5/2011, and even a year, just 2011.
Rick
On May 11, 2011, at 6:00 PM, FMPRO-L automatic digest system wrote:
1. Finding a range of dates
----------------------------------------------------------------------
Date: Wed, 11 May 2011 12:38:21 +0200
From: Bruce Button<[email protected]>
Subject: Finding a range of dates
This is a multi-part message in MIME format.
--------------030508080902070108080705
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
I have a real puzzle (for me anyway!).
I can find a range of dates by entering */{1..3}/2011 in the
date field (in find mode), but if I enter anything with a
greater than or less than operator (like<4/14/2011) FMP
tells me that the find criteria are invalid.
Any help would be appreciated.
(I'm using FMPA 11 on Windows 7)
Bruce Button
___________________
Rick O’Quinn
Photographic Services Coordinator
University of Georgia
Public Affairs
Broadcast, Video& Photographic Services
188 Georgia Center
Athens GA 30602-3603
Work: (706) 542-8085
Fax: (706) 583-0011
[email protected]
http://www.photo.alumni.uga.edu
