Lowest and highest Time

[Ron]

Hi there,

I have a bunch of related records that include times eg.

 

 

Act Start Finish

Gocat go 7.00pm 8.00pm

other act 8.30pm 10.30pm

 

I would like to extract the range 7.00pm - 10.30pm

 

Any suggestions would be appreciated.

 

Kind regareds Ron

[Ender]

So you need the Min (relationship::Start) and the Max(relationship::End)?

[Ron]

Thanks sincerely Ender....

[LaRetta]

If you have a lot of records, Min() and Max() are resource-hungry. Another option is to use two little table occurrences and let the relationship sort them so only the first record in each table occurrence is the one FM sees (as in all relationships).

 

Create another table occurrence of your related file called Start. Use cartesian join from any field except container as: MainFile::anyField X StartTime (and sort this new TO on Start Time ascending).

 

Create another table occurrence of your related file called End. Use cartesian join from any field except container as: MainFile::anyField X EndTime (and sort this TO on End Time DESCENDING).

 

Then your two calcs: cMinStartTime = Start::StartTime and cMaxEndTime = End::EndTime. It will use two new table occurrences but will be very easy on resources. It will display much more quickly.

 

LaRetta smiley-smile