P
PMK
I run several teams that conduct works on monday to friday.
Sometimes the job takes one day, sometimes longer.
What I require is some "Date Addition" coding that will allow me to
automatically (from an initial start date) add each consecutive
date to my database based on the number of days I estimate the job
to take. Saturdays and sunday are excluded. I require this
facility as I produce a form each day (that contains all the new
jobs for that day and jobs that are currently ongoing)
To clarify:-
One job begins Monday 7th February 2005 and lasts for 4 days. I
want to, without having to type into my database the job reference
number for the job plus 08/02/2005, then 09/02/2005 and finally
10/02/2005 for each of the days.
So basically all i want is to add the start date of a job and the
number of days that the job will take and then have some coding
that will allow for the additional dates to be entered into the
same table/query without me having to do it all manually.
So for Job 1, I enter start date as 07/02/2005 and then add the number of
estimated days for the job to be completed eg 4 and thus what I wish to see
in my table/query is (after application of the appropriate coding)
Job 0001 07/02/2005 4 days
Job 0001 08/02/2005 3 days
Job 0001 09/02/2005 2 days
Job 0001 10/02/2005 1 days
As a further thought would it be possible to reduce the number by
one for each day i.e.
Job 0001 07/02/2005 4 days
Job 0001 08/02/2005 3 days
Job 0001 09/02/2005 2 days
Job 0001 10/02/2005 1 days
Again, thanking you all in anticipation
PMK
PS - Sorry for this all being long-winded but hopefully I have somehow made
my requirments cogent.
Sometimes the job takes one day, sometimes longer.
What I require is some "Date Addition" coding that will allow me to
automatically (from an initial start date) add each consecutive
date to my database based on the number of days I estimate the job
to take. Saturdays and sunday are excluded. I require this
facility as I produce a form each day (that contains all the new
jobs for that day and jobs that are currently ongoing)
To clarify:-
One job begins Monday 7th February 2005 and lasts for 4 days. I
want to, without having to type into my database the job reference
number for the job plus 08/02/2005, then 09/02/2005 and finally
10/02/2005 for each of the days.
So basically all i want is to add the start date of a job and the
number of days that the job will take and then have some coding
that will allow for the additional dates to be entered into the
same table/query without me having to do it all manually.
So for Job 1, I enter start date as 07/02/2005 and then add the number of
estimated days for the job to be completed eg 4 and thus what I wish to see
in my table/query is (after application of the appropriate coding)
Job 0001 07/02/2005 4 days
Job 0001 08/02/2005 3 days
Job 0001 09/02/2005 2 days
Job 0001 10/02/2005 1 days
As a further thought would it be possible to reduce the number by
one for each day i.e.
Job 0001 07/02/2005 4 days
Job 0001 08/02/2005 3 days
Job 0001 09/02/2005 2 days
Job 0001 10/02/2005 1 days
Again, thanking you all in anticipation
PMK
PS - Sorry for this all being long-winded but hopefully I have somehow made
my requirments cogent.