I am using FMP 7 on Windows XP.

I am trying to enter a find request that will take the date I enter for the
find and then add four more days to the find. So if I do a find for
December 12, I will end up with Dec 12, 13, 14, 15, and 16.

The date field I am using is called PB Date. I have about 300 records,
dated from August to June.

What kind of find entry do I need to make to get the date I enter plus the
next four days????

TIA

Wish I could find a date in the next four days

Try "date...other date". The ellipsis will find you all the dates in
between the two you put in, inclusive.

-G

Thank you.

Is there a way of automating this so if I enter the first date, something
like "+4" is automatically added? I will need to do many of these and if I
can simplify things it would be very helpful.

I can make a script, but I don't know what to add to the first date that
would be like my "+4" above to give the same results.



"Grip" <grip (AT) cybermesa (DOT) com> wrote

Newbie effort ...:

MyDate is the date you're searching through.
Date1 is the start date as a date field.
Date2 is the end date as a calculation = Date1 + 4

Make a copy of the Myfile in the Table graph.
So that you have Myfile1 and Myfile2
Make a double relationship between Myfile1 and Myfile2 using
Date1 >= MyDate AND
Date2 <= MyDate to
Now in a layout based on Mayfile1, stick a portal based on Myfile2.

Does that work ?

Maude








"Stephen Larivee" <NOlariveeslSPAM (AT) yahoo (DOT) PLEASEcom> a écrit dans le message
de news: zfCdnZc46ZAfganeRVn-vQ (AT) comcast (DOT) com...

In article <zfCdnZc46ZAfganeRVn-vQ (AT) comcast (DOT) com>,
NOlariveeslSPAM (AT) yahoo (DOT) PLEASEcom says...
write the script, take it to a screen to allow entry of the start date
to a global (called say "inputdate", wait for user input, then enter
find mode, insert calculated result into the actual date:

(datetotext(inputdate) & "..." & datetotext(inputdate+4)

perform find.

voila.

-Dave

Getting the result that DATETOTEXT is not a valid request.



"42" <nospam (AT) nospam (DOT) com> wrote

In article <vpGdnbY50utMzqneRVn-qw (AT) comcast (DOT) com>,
NOlariveeslSPAM (AT) yahoo (DOT) PLEASEcom says...
You'll have to get used to the fact that much of the code presented here
is pseudocode and/or code from differing flavours of FM. In particular
FM7 revises the names of several dozen pre-existing functions.

Many of the code snippets posted here require some "reinterpretation" to
work.

In this case FM7 calls it: GetAsText(zzzz)

cheers,
Dave

Thank you for your help....and patience.


"42" <nospam (AT) nospam (DOT) com> wrote

As you have no doubt guessed, I am a beginner here. I am trying the
recommendation from "42" since it looks more familiar to me. Thank you for
your input. I will examine it later to see if I can get it to work.

Thanks again.



"Maude Sansechek" <Maude.Sansechek (AT) Sansechek (DOT) net> wrote