calculation that shows next available date ???

[Steven Cappiello]

Hi,

How can I get a calculation to look at a table of dates and generate the next available date for something ?

An example of how I need to use this follows:

For every employee that joins the company, they need to

1. have an initial meeting with the boss

2. go to employee orientation

3. get trained on the purchasing system

Let's say the boss only meets people on the 1st and 15th of each month.

Then, Employee Orientation happens every two weeks.. (1/4, 1/18, 2/1, 2/15, 2/29...)

Purchasing System training only happens every two months (1/23, 3/23, 5/23...)

How I'd like the system to work is:

for each new employee, we'd schedule the date that the person meets with the boss,

and then the other two dates would auto-generate based on the next available date.

I'm not sure though:

1. how to get a calculation to do this.. (what is the function I should be using ?)

2. should these series of dates (boss meetings, orientation meetings, etc.) exist in their own tables ?

I guess I feel like this seems this shouldn't be difficult at all, (and I certainly don't want to overcomplicate it).. but I'm a little confused.

Any help or push in the right direction would be appreciated !!

thanks.

[PeterHW]

Hi djbeta,

thought that was an interesting question. I'm going to make a long story short by including a sample file. The "Dates" table needs to be manually filled, but you could also make a script that populates it. I have also entered the "Boss Meeting" dates, so you can use these in a pop-up list from the "Main" table to view all available dates.

I'm sure there are other ways of doing this, but this works pretty much as you've requested.

HTH,

Peter

Dates.zip

[Steven Cappiello]

Very cool! what a simple solution. -) thanks.

I think this technique will work perfectly for me.

[comment]

This may help you generate the dates.

[PeterHW]

Glad I could help, good luck,

Peter

[PeterHW]

Cool stuff Comment ! That one might come in handy every now and then !

Regards,

Peter

[Steven Cappiello]

cool! thanks