Here is a weird anomoly:

This report is sub-summarized on Company and then on OptionSymbol. It works well.

At the top of the report is a global field g.LowerTransactionDate. I have a script trigger on this field that runs this script:

When I enter Apr-11-2009 I don't get Expiration Dates GREATER than that date for both WellsFargo and Apple. I just get the values for Apple.

What am I doing wrong?

Edited July 18, 200916 yr by Guest

Why are you constraining your found set? If you have another portion of the find script that we are not seeing (prior to this) that produces a found set (and you are only showing the constrain portion) then your problem probably exists there (in the prior script portion. If this *IS* your find script then you should be using Perform Find [] and not constrain. :wink2:

Thank you for the reply.

There is no script in the production of the original sub-summary layout.

The problem is as follows:

There are 2 global date fields at the top.

g.lowerTransactionDate -

g.uppertransactiondate.

Originally I wanted FM to dynamically change the displayed records as the lower date was selected and then again when the upperdate was selected. But, since I can't tell if the user starts with the lower or starts with the upperdate the attached script to each could not reliably use Perform Find vs Constrain Found set.

So, I decided to collect both dates and then use a single button to execute a FIND on the combined dates. That script is in the .jpg above.

I am not sure if the syntax is correct but the affect is it doesn't work. I have fooled around with different syntax combinations and nothing seems to really work.

This script is:

Enter Find Mode[]

Set Field [OptionTransactions::expdate; ">" & Global::g.lowerTransactionDate & "and" & "<" & Global::g.upperTransactionDate]

Peform Find[]

Sort Records [Restore;No Dialog]

When I run debug, nothing is entered in the search field (expdate).

Got any ideas??

Edited July 19, 200916 yr by Guest