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" <[log in to unmask]>
To: <[log in to unmask]>
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: