Thank you very much. The Insert Calculated Result worked. That was a life
saver; I have spent three hours trying to make the Set Field version work
and looking into help for anything about dates and ranges. Did not find
anything. The help has a very limited search engine. There is nothing in the
Insert Calculated Result page about date ranges and not turns up for "date
range".
In the script my date ranges are correct and did not have any trouble with
that.
----- Original Message -----
From: "Steve Cassidy" <[email protected]>
To: <[email protected]>
Sent: Wednesday, June 09, 2010 3:41 PM
Subject: Re: Cannot programmically enter date range in Find mode
Nicholas
Yes, you've discovered one of the oddities in Filemaker pre .fp7. But
this is documented in the user manual and the help.
Filemaker expects a date in a date field, even in Find mode. Doesn't
really make sense, but there you go.
The workaround is to use a script step called something like Insert
Calculated Result or Paste Result (sorry, I only have a Japanese version
handy so I can't check this easily). The name changed at some point in
the version history.
The point about this step is that the field has to be on the current
layout. So it is not as useful as Set Field. But it will allow you to do
what you want.
Steve
PS Incidentally, I think you have your start and end dates the wrong way
round. The first date must be earlier than the second one.
On Jun 9, 2010, at 8:17 PM, Nicholas Geti wrote:
