hi, all. windows xp, fm 6.0v4
i have a 'bank deposit" file into which I enter the invoice number,
check number, check amount
for client checks. the bank deposit file is related on invoice number
to my master work file called 'docket index'. the bank deposit file
sums the total of invoices to make sure it matches with the check
amount. At the end of a batch of checks I have a script which updates
a PayConfirmNum field in the master docket index file with the
following info:
Set Field["Docket Index::PayConfirmNum","CNT & CheckNum & "D"
&DateToText(Today)"]
Client is ALEX A, CHECK NUMBER IS 1782 AND the date IS 5/15/2007
The result in PayConfirmNum is ALEX A1782D5/15/2007

Now I want to do a search on the PayConfirmNum field to find all the
invoices marked paid on 5/15/2007, but I repeatedly get
"no matching records" DateToText is obiously messing with something,
but i cant find a clue in the help tab.

Thanks in advance

FileMaker finds based on "words" beginning with your search criteria.
Since there is no space before the date, a standard find won't find the
date. It should work, though if you search for "*5/15/2007" (without
the quotes). You should note that since this is not a date, you will of
course not get any results if you search for *5/15/07 or for a date
range (5/1/2007...5/31/2007) or (5/*/2007 -- though I guess *5/*/2007
will work).

You are really much better off for a variety of reasons to use three
separate fields for client, check num and date paid.

afernlund_me_at (AT) gmail (DOT) com wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance