Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Extending a find based on a Date Range

Featured Replies

Hi,

I have a problem where I am trying do a date search for specific comments that relate to a person in my database. The first thing that happens is that I do a

Go to Related Record based off a value list of ID numbers

eg. a person is assoicated with a number a objects now each of those objects have a number of comments attached to it so a value list is being created in the person table of all of the objects that a person has and then a relationship has been setup between that value List and the comments table and when a goto related record in the comments table it brings up all of the comments for that person.

What I am wanting to do is allow a user to enter a date range and the rest of the orginal find will be refined to the date critera (if that makes sense).

now what i am doing at the moment is:

- copying the from date (as i was trying to get it working and then move onto a date range)

- doing the go related record which brings up only related records

- Modify Last Find

- Pausing the script

- Pasting the date into the appropriate field

- Perform Find[Extend Found Set]

but it keeps telling me there is not results and brings back all of the records??

Any help would be greatly appreciated

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.