Earliest Date of a sorted record set

[svolin]

I have a problem extracting the earliest date in a set of filtered and sorted records. Both the 'GetRecord' and 'Min' functions return the lowest record number, rather than the record with the earliest date. I have to sort by by name by month, quarter and year (separate layouts) and i want to show the actual earliest and latest dates in the Trailing Grand Summary. Thanks for any help

[comment]

Try a summary field defined as Minimum of [Datefield].

This is assuming by "set" you mean "found set" and that Datefield is of type Date. Records do not have to be sorted by Datefield for this.

Alternatively, if your records ARE sorted by Datefield, ascending, then =

GetNthRecord ( Datefield ; 1 )

will return the earliest date, and =

GetNthRecord ( Datefield ; Get ( FoundCount ) )

the latest (these calculations need to be unstored).

[svolin]

Thanks. Works like a charm. So Simple - That loud, rhythmic thud you hear is me, beating my head against the wall.

Again, Thanks