Jump to content
Sign in to follow this  
richshone

validated date range finds

Recommended Posts

I need help with a date field/date range question... I am and event/tour coordinator and I have two related files, one we will call events, the other we will call personnel. I would like to be able to keep lists of people involved in a particular 'tour' or set of events in my personnel file - which has start date and end date fields - so I can easily navigate from my events file to the correct list based on the event date in question. My key field would either be the client name or the tour name (I haven't decided yet which would work best).

Any suggestions as to how to do this? One problem is that a number of 'tours' could have open end dates until (a) personnel change or (: the said tour is over. I don't know if this would gum up the works but I could find a work around for that if necessary... thanks

Share this post


Link to post
Share on other sites

quote:

Originally posted by richshone:

I need help with a date field/date range question... I am and event/tour coordinator and I have two related files, one we will call events, the other we will call personnel. I would like to be able to keep lists of people involved in a particular 'tour' or set of events in my personnel file - which has start date and end date fields - so I can easily navigate from my events file to the correct list based on the event date in question. My key field would either be the client name or the tour name (I haven't decided yet which would work best).

Any suggestions as to how to do this? One problem is that a number of 'tours' could have open end dates until (a) personnel change or (: the said tour is over. I don't know if this would gum up the works but I could find a work around for that if necessary... thanks

Share this post


Link to post
Share on other sites

quote:

Originally posted by BMoseid:

Originally posted by richshone:

[qb]I need help with a date field/date range question... I am and event/tour coordinator and I have two related files, one we will call events, the other we will call personnel. I would like to be able to keep lists of people involved in a particular 'tour' or set of events in my personnel file - which has start date and end date fields - so I can easily navigate from my events file to the correct list based on the event date in question. My key field would either be the client name or the tour name (I haven't decided yet which would work best).

Try the Troi/ISO Productions Range Plug-In. I've used it to automatically generate a series of dates, either mm/dd/yyyy or xxxxx (FMPs's internal date) the result can be used in a relationship to quickly "find" the desired set of records. Check out he Plug-In at:

and

Any suggestions as to how to do this? One problem is that a number of 'tours' could have open end dates until (a) personnel change or (: the said tour is over. I don't know if this would gum up the works but I could find a work around for that if necessary... thanks

[/QB]

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.