I'm trying to create a layout to do finds on certain fields and also a date
range.

I created a layout with a Start date (date field) and a End Date (Date
field) using also the calendar option in the field control.
I also created a Range field ( text field with gives the calculated result:
Start Date&...&End Date)

That works OK in browse mode. If I put a Start and End Date, I immediatly
get a date range.
2005/10/01...2005/10/31 (international date format)

BUT that doesn't work when I'm in FIND mode. I can put the Start and End
Date but I don't get the calculated result....
Nothing shows up in the Range field.

What I'm I doing wrong ??

Thanks for the input

You should use globals and a small script and stay in Browse mode
(people don't really understand how the 'Find' mode works). (I am in
FMP6).
You fill up 'gStartDate' of a 'date' type and the same for 'gEndDate'.
You're looking for records in which the field 'Date1' contents is
between the two search dates.
Your 'Find' script may look like :

Enter Browse mode
Go to layout (Record) **** the field 'Date1' has to be visible in this
layout****
Enter Find mode
Insert Calculated Result( Select, Date1,DateToText(gStartDate) & "..." &
DateToText(gEndDate))
Perform find

Remi-Noel


"Claude Carlos" <carlos.cl (AT) videotron (DOT) ca> a écrit dans le message de
news: 3Ko8f.27047$Ts.244799 (AT) weber (DOT) videotron.net...

The reason you're not getting a result in the calculation field in Find
mode is because you can search calc fields just like any other field so
therefore they must allow data entry and can not calculate a result.

You can use the same approach that Remi-Noel described in Find mode
also.
Before FileMaker 7 you had to use the "Insert Calculated Result" script
step to put a date range into a date field in find mode. Now you can
use Set Field which is better since it doesn't require the field to be
on the screen.