Steven Cappiello Posted March 1, 2005 Share Posted March 1, 2005 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. Link to comment Share on other sites More sharing options...
This topic is 6604 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
Already have an account? Sign in here.Sign In Now