Searching a date field for values between two dates

[ron G]

I have report layout based on a table called TRANSACTONS

I have a field Transactions::TransactionDate which holds .... yes.... transaction dates.

I want to put two global fields in the header ....

g.lowerdate and g.upperdate.

Then I want to locate all records where the transactionDate is between g.lowerdate and g.upperdate.

It seems that FM PERFORM FIND () function will not allow me to specify a criteria for a global field??? It seems like I can't specify a criteria where the transactiondate > g.lowerdate Or is there a 'trick' I am missing?

[mr_vodka]

Please see examples in this ongoing thread.

http://fmforums.com/forum/showtopic.php?tid/209788

[ron G]

Ah... I forgot to use the concatenation symbol and quotes.... Thanks for the link.

[ron G]

Here is a weird anomoly:

As you can see, this report has 2 sub-summary sections: Stock Name and within Stock Name it is summarized by Option Symbol. The report works great.

But, if I put in a start date of July 11, 2009 I will get a listing of those Options for Apple with an Expiration Date > July 11, 2009. Great. This works as desired.

However, if I press the SHOW ALL button, I get:

First a listing of ALL Apple options.

If I press it a 2nd time, I get the listing to include all options for Wellsfargo.

Of course the Show All button runs a simple script that is:

Show All Records

Sort Records [Restore; No dialog]

(sorting is by stockname and then optsymbol.

Have you any idea how to fix my code to really show ALL options for ALL stocks with a single press?