Complex Date Calculation

  • Thread starter terranauro via AccessMonster.com
  • Start date
T

terranauro via AccessMonster.com

Dear All Access Expert of this fantastic site

I have problem which I describe as follow :

Suppose I have a working schedule which is lasted
for one month, for example from Sep 1st until
September 30th.
What make it complex is that not everyday I have
to work, suppose only from monday until thursday
every week.
What I am asking you is :

How I calculate amount of my working days within
specific period ?
For example : within 1 month (september) or maybe
only within 2 weeks (sep 7th until
Sep 21st)


Is it possible to perform this calculation automatically ?


Many thanks in advance for your help


Sincerely Yours


Terran
 
J

John W. Vinson

Dear All Access Expert of this fantastic site

I have problem which I describe as follow :

Suppose I have a working schedule which is lasted
for one month, for example from Sep 1st until
September 30th.
What make it complex is that not everyday I have
to work, suppose only from monday until thursday
every week.
What I am asking you is :

How I calculate amount of my working days within
specific period ?
For example : within 1 month (september) or maybe
only within 2 weeks (sep 7th until
Sep 21st)


Is it possible to perform this calculation automatically ?
Click to expand...

You'll need to keep track somehow of not only weekends but also company
holidays. Your best solution may be to create a Workdays table with a
datefield and another field (or fields) to indicate if this is a workday. Fill
it (say using Excel Insert... Fill Series) with every day from now for the
next ten years or so, and (manually or programmatically) flag the working
days. You can then simply run a query of this table with a date range and
count only workdays.
 
T

terranauro via AccessMonster.com

Dear Mr. John Vinson

Thank you for your quick response.

As I said before, I knew that this is gonna be difficult to perform
programmatically.

But thanks anyway for your idea.
I will try that and make report of my progress.
Again, thank you very much.

Sincerely yours


Hendra Himawan
 
Top