R
Rags
Need some help with the dhCountWorkdaysA and WorkingDays2 modules to exclude
holidays in calculations between 2 dates. I've tried using both in a report I
created and they both work except for some issues.
I'm using =IIf(dhCountWorkdaysA([Batchtime],[Completetime])<5,[Issues],0) in
the control source of a text box in a report and it works fine to exclude
weekends. I tried using the optional atmDates variant array and it works with
1 holiday date but not more than 1. The report runs very quickly.
I'm using =IIf(WorkingDays2([Batchtime],[Completetime])<5,[Issues],0) in the
control source of a copy of the same report and it works fine to exclude
weekends and holidays. (tblHolidays table contains 8 holiday dates) Problem
is the report runs very slow for the same date range as the other one.
(unless that's normal)
Can anyone point me in the right direction to get either 1 to exlude
holidays and work quickly. Both reports run from the same database using the
same network setup and connections. I'm still learning VB so am not that
familiar with any alternative programming. There are approximately 39000 rows
in the table I'm querying in the Access2003 database.
Any help would be appreciated. Thanks.
holidays in calculations between 2 dates. I've tried using both in a report I
created and they both work except for some issues.
I'm using =IIf(dhCountWorkdaysA([Batchtime],[Completetime])<5,[Issues],0) in
the control source of a text box in a report and it works fine to exclude
weekends. I tried using the optional atmDates variant array and it works with
1 holiday date but not more than 1. The report runs very quickly.
I'm using =IIf(WorkingDays2([Batchtime],[Completetime])<5,[Issues],0) in the
control source of a copy of the same report and it works fine to exclude
weekends and holidays. (tblHolidays table contains 8 holiday dates) Problem
is the report runs very slow for the same date range as the other one.
(unless that's normal)
Can anyone point me in the right direction to get either 1 to exlude
holidays and work quickly. Both reports run from the same database using the
same network setup and connections. I'm still learning VB so am not that
familiar with any alternative programming. There are approximately 39000 rows
in the table I'm querying in the Access2003 database.
Any help would be appreciated. Thanks.