I would like to find records between specific dates. I know, i could
type date1...date2 to achieve this. However. I would like to create two
fields:
start date
and
end date.
By typing dates inside I would like to find records within this dates.

Filemaker 8.5 Advanced
Mac OSX 10.4.9
iMac G5

TT <ping (AT) zg (DOT) htnet.hr> wrote:

Create two global fields for that purposte.

Then you can either create a script that enters the find request for you
or use a portal with a self-join:

Put a second instance of the table on the relation graph and create a
relation based on two pairs of fields:

Table:ate >= SearchTable::GlobalDate1
Table:ate <= SearchTable::GlobalDate2

--
http://clk.ch

Christoph Kaufmann wrote:
in table called "Trips" i added following fields:
start date - (type)date
end date - (type)date
gstart date - (type)date, (options)global
gend date - (type)date, (options)global

In relationships I created another table called "trips 2" and create
relationship
Trips::start date >= Trips 2::gstart date
Trips::end date >= Trips 2::gend date

In table "Trip" I press find and in start and end date I input requested
data. By pressing enter, I received message;
"No records match this request."

TT <ping (AT) zg (DOT) htnet.hr> wrote:

If you're trying to perform the find over two Date fields, then you'll
have to do the following "Or Find" procedure ...

1. Enter Find mode

2. Go to the StartDate field and type in "date1...date2"
(without the quote marks)
Do NOT perform the Find yet.

3. Create a New Request via the Requests menu
(when in Find mode the Records menu changes its name)

4. In the new blank request that appears, go to the
EndDate field and type in "date1...date2"
(without the quote marks)

5. NOW perform the Find. FileMaker will return all records
with a StartDate OR an EndDate between, and including,
date1 and date2


Step 2 tells FileMaker you want records with a StartDate between date1
and date2.

Step 4 tells FileMaker you want records with a StartDate between date1
and date2.

Step 3, creating a new Find request, tells FileMaker you want records
that match either the first request OR the second request (or both).


If you type "date1...date2" into both fields on the same Find Request,
then you are performing an "And Find" - you're telling FileMaker you
want records that have a StartDate AND an EndDate betwen and including
date1 and date - any records with a StartDate or End date outside that
range will not match.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On May 9, 11:00 am, TT <p... (AT) zg (DOT) htnet.hr> wrote:
FWIW... If it's just a simple find of a date range, I use 3 fields:

Original Date = the date field that you want to search
gStart = Global Date Field
gStop = Global Date Field

Then I create a "find" script:

Enter Find Mode [ ]
Set Field [Original Date ; gStart & "..." & gStop]
Perform Find [ ]

if you want to then further narrow down the data, you want to use
Constrain Found Set, so that you don't lose the date range you just
created, i.e....

Enter Find Mode [ ]
Set Field [Original Date ; gStart & "..." & gStop]
Perform Find [ ]
Constrain Found Set [Restore]
Constrain Found Set [Restore] etc...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
....amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 64Bit / FMP Adv 8.5v2
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-