Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Lowest and highest Time


Ron
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use