Number of days between two dates excluding Holidays and weekends.

[Bunky]

I am trying to calculate the number of days between two dates excluding
weekends and holidays. I have seen and read several posts out on the web
that does this but now have a couple of questions.

1. How do I incorporate the VB coding on the web into a query? The table
that I must run against is over 200,000 rows and I must do this day
difference based on several dates on each row.

2. What makes one of the programs better than another found on the web? I
know extremely little VB code and have picked the wrong one before. Any
suggestions as to which one to use would be appreciated.

Thank you in advance for your assistance.

 

[S.Clark]

Any public function can be called from an Access Query.

e.g.
Select fields from tablename WHERE [SomeDate] < GetNumberofBizDays()
Select GetFY([SomeDate]) from tablename where ...

Free code is like free beer.

 

[BruceM]

How do you characterize free beer?

Any public function can be called from an Access Query.

e.g.
Select fields from tablename WHERE [SomeDate] < GetNumberofBizDays()
Select GetFY([SomeDate]) from tablename where ...

Free code is like free beer.

I am trying to calculate the number of days between two dates excluding
weekends and holidays. I have seen and read several posts out on the web
that does this but now have a couple of questions.

1. How do I incorporate the VB coding on the web into a query? The table
that I must run against is over 200,000 rows and I must do this day
difference based on several dates on each row.

2. What makes one of the programs better than another found on the web?
I
know extremely little VB code and have picked the wrong one before. Any
suggestions as to which one to use would be appreciated.

Thank you in advance for your assistance.

 

[S.Clark]

The price is right, and it will typically get the job done... if you can
stand the side effects. I turn down any Budweiser, because it takes horrible
and usually gives me a headache.

How do you characterize free beer?

Any public function can be called from an Access Query.

e.g.
Select fields from tablename WHERE [SomeDate] < GetNumberofBizDays()
Select GetFY([SomeDate]) from tablename where ...

Free code is like free beer.

I am trying to calculate the number of days between two dates excluding
weekends and holidays. I have seen and read several posts out on the web
that does this but now have a couple of questions.

1. How do I incorporate the VB coding on the web into a query? The table
that I must run against is over 200,000 rows and I must do this day
difference based on several dates on each row.

2. What makes one of the programs better than another found on the web?
I
know extremely little VB code and have picked the wrong one before. Any
suggestions as to which one to use would be appreciated.

Thank you in advance for your assistance.

 

[BruceM]

I have to say there is a lot of very good code available for free online.
In some cases the free code is the best (or only) way to get the job done.
For instance, Lebans mouse wheel utility does not have a commercial
counterpart of which I am aware. The free code and techiniques many
developers make available is stuff they use in their own applications, and
is remarkably free from side effects.
That being said, there is no small amount of funky code out there. It takes
some practice to see the difference between the quality microbrews and the
lower echelon concoctions.

The price is right, and it will typically get the job done... if you can
stand the side effects. I turn down any Budweiser, because it takes
horrible
and usually gives me a headache.

How do you characterize free beer?

Any public function can be called from an Access Query.

e.g.
Select fields from tablename WHERE [SomeDate] < GetNumberofBizDays()
Select GetFY([SomeDate]) from tablename where ...

Free code is like free beer.

:
I am trying to calculate the number of days between two dates
excluding
weekends and holidays. I have seen and read several posts out on the
web
that does this but now have a couple of questions.

1. How do I incorporate the VB coding on the web into a query? The
table
that I must run against is over 200,000 rows and I must do this day
difference based on several dates on each row.

2. What makes one of the programs better than another found on the
web?
I
know extremely little VB code and have picked the wrong one before.
Any
suggestions as to which one to use would be appreciated.

Thank you in advance for your assistance.