How get highest and lowest dates for a report

#1

Hi,

I want to print the date range of a found set on a report. Any ideas how
to grab this information.

Thanks,

Dale

#2

Freeze window, sort by date, go to first record, set a global date field to
date, go to last record, set another global date field to date, use the
global fields in a merge field to display the date range, eg:

<<gDate1>> to <<gDate2>>

Format the dates by selecting the text object in layout mode then using the
Date command in the Format menu.

Bridget Eley

in article dglaser-2630D9.13530905082003 (AT) c... supernews.com, Dale
Glaser at dglaser (AT) pacific (DOT) net wrote on 6/8/03 6:53 AM:

Quote:

Hi,

I want to print the date range of a found set on a report. Any ideas how
to grab this information.

Thanks,

Dale

#3

Sorry, Matt, my mistake: I somehow missed the part about Summary fields and
just assumed you were using the Max and Min functions. Your solution does
work with the current found set, and seemed fractionally faster than sorting
the records when I tested it on a 50000+ record set in a single-user
environment.

Bridget Eley

in article BB57985B.1D420%matt (AT) thesoftwareman (DOT) com, Matt Revenaugh at
matt (AT) thesoftwareman (DOT) com wrote on 7/8/03 10:46 PM:

Quote:

in article BB564CBA.1D3F4%matt (AT) thesoftwareman (DOT) com, Matt Revenaugh at
matt (AT) thesoftwareman (DOT) com wrote on 6/8/03 11:11 PM:

Try and make summary fields that gets the minimum and maximum dates of the
found records.

As long as you are printing the max and min in a page header or page footer
you will find it to be an easy way to do what you want.

I use the merge field technique:
MinReportDate>> thru <<MaxReportDate

---------

On 8/6/03 1:44 PM, in article BB57A5E1.2529%bridgeteley (AT) ihug (DOT) com.au,
"Bridget Eley" <bridgeteley (AT) ihug (DOT) com.au> wrote:

You would need to use a related field within the Max and Min functions to
make this work....

I'm sorry, but you do NOT need a related field to make this work. I just
tried it! Try it yourself. You may find a surprise.

Matt Revenaugh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How get highest and lowest dates for a report

comp.databases.filemaker comp.databases.filemaker

How get highest and lowest dates for a report - 08-05-2003 , 03:53 PM

Re: How get highest and lowest dates for a report - 08-05-2003 , 04:36 PM

Re: How get highest and lowest dates for a report - 08-07-2003 , 03:17 PM