Not real sure what you're trying to do here. Are you performing the find in
a Customer file, or in an Orders file? If the Modify Find were replaced with
the New Record/Request that I think you intended (more on that later), then
your request would find all those Customers/Orders with a date >= the
newdate AND those with a date < newdate... which comes out to any
Customer/Order that has any date at all.
Assuming (for the moment) that this is the Customer file, what if you had a
"First Order" date instead of the date of their last order? You could set
this value when the customer is set up or when the first order is placed.
Alternately, you could create a relationship to Orders, sorted by date, and
just pull the first date from that relationship. By searching this date,
you'd get those whose FIRST order was after newdate, which seems to be what
Some general suggestions about scripting that might help, regardless:
-"Modify Last Find" enters the Find mode and restores the previous find
request. I believe what you're looking for is "New Record/Request", which is
"the 'Add New Request' command when processing the request manually"
-Stay away from the Copy, Paste and Insert commands wherever possible. Use
Set Field instead. Set Field doesn't require the field to be on a layout,
and also doesn't overwrite the user's clipboard (whatever the user last
copied or cut).
-That being said, inserting ">=" in a date field is one of the VERY few
instances where Set Field won't work. Instead of doing two steps, though,
consider using Insert Calculated Result [Select, ">=" & date]
I am trying to create a multiple find in a script for the purpose of
finding a customer base that defined as NEW. New is defined as a
customer that has purchased product from a given date but not prior to
So far I have figured out how to find a listing of those customers who
have purchased product from the given date (the easy part), but how to
determine and eliminate any of those customers who have purchased
products prior to the date and after the date to eliminate them from
the NEW definition is what I can't seem to resolve.
I need a workable algorithm. What I have is the following and it
doesn't seem to get me what I need.
newdate: Global date variable
date: Date product was sold to customer
After the user enters a date in the "newdate" field the following
script is initiated.
Copy [Select, "newdate"]
Enter Find Mode
Insert Text [Select,"date",">="]
Modify Last Find
Insert Text [Select,"date","<"]
The MODIFY LAST FIND command is used to replace the "Add New Request"
command when processing the request manually.
Email responses should be sent to the following: