Hi,
I have a DB where there is a recall date field. I then have a
concatenated future recall date calc field. The idea is I need to
seach for people who need to be recall within a certain date range.

Ex.

recalldate: 03/15/2007

allfuturedates: 03/15/2007
03/15/2008
03/15/2009
03/15/2010

this way if they dont come back, they'll end up getting a recall card
again on their anniversary date. All I need to do is search for a
date range within the "allfuturedates".

I'm having trouble with it though, any ideas?
thanks in advance! -Kevin

You don't say what version of FileMaker, but in FM 7 or 8 you can search
for " 3/15/* "

drrehak (AT) yahoo (DOT) com wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

In article <1176500725.210673.50000 (AT) n76g2000hsh (DOT) googlegroups.com>,
drrehak (AT) yahoo (DOT) com wrote:

AllFutureDates must be a Calculation field with a Text result since you
can't concatenate to a Date result.

You don't say, but presumably you've got a "Search" script which enters
Find mode, puts a copy of the value from RecallDate (likely a Global
Date field) into AllFutureDates and then performs the Find.

This means that if RecallDate is a Date field (or Global Date field or
Calculation field witha Date result) you're going to have problems -
despite the fact that they look the same, the internal formats are
completely different, so searching for the date "13/5/2007" in a Text
field won't find any records.

In this case you first need to re-format the RecallDate into Text using
the DateToText function.
eg.
Enter Find Mode []
Set Field [AllFutureDates, DateToText(RecallDate)]
Perform Find


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