I hope someone can help me.
Iam currently constructing a database to track information requests made to our organisation. I have done a number of searches on working days and have got two or three solutions that will calculate the working days btw two dates. What I need to do is, given a starting date, what would be the date be 20 working days ahead. This interval is constant. I've tried making sense of the modules but I am getting lost and confused.
In addition, I also need a way to alter the end date should the process be interrupted. When it restarts, the request clock restarts at the point it stopped. I therefore need to calculate how many days elapsed prior to the interrupt and then use this to subtract from the 20 alloted working days and then add the difference to the restart date. Because the working period has been set by legislation, it is vital that we get this right.
If it can't be done, I'll use Outlook to count the days manually!
Thanks in advance
David
Iam currently constructing a database to track information requests made to our organisation. I have done a number of searches on working days and have got two or three solutions that will calculate the working days btw two dates. What I need to do is, given a starting date, what would be the date be 20 working days ahead. This interval is constant. I've tried making sense of the modules but I am getting lost and confused.
In addition, I also need a way to alter the end date should the process be interrupted. When it restarts, the request clock restarts at the point it stopped. I therefore need to calculate how many days elapsed prior to the interrupt and then use this to subtract from the 20 alloted working days and then add the difference to the restart date. Because the working period has been set by legislation, it is vital that we get this right.
If it can't be done, I'll use Outlook to count the days manually!
Thanks in advance
David
