Jump to content
Sign in to follow this  
DSTUART

Extending a find based on a Date Range

Recommended Posts

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

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