Jump to content

validated date range finds


richshone
 Share

This topic is 7460 days old. Please don't post here. Open a new topic instead.

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

Link to comment
Share on other sites

  • 3 weeks later...
  • Newbies

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

Link to comment
Share on other sites

  • Newbies

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]

Link to comment
Share on other sites

This topic is 7460 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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