count workdays

G

Guest

I copied the VB from the web and used the function
dhCountWorkDaysA
I have the formula on the query:
dhCountWorkDaysA([Fund], [Draw])
Both of the field are date format
When I add the array:
dhCountWorkDaysA([Fund], [Draw], Array(#11/11/2004#, #11/26/2004#))
I get a type mismatch, can someone tell me what's wrong.

Thanks
 
D

Duane Hookom

Do you understand that "format" and "data type" are different? Are the
fields date/time types? A trust you haven't placed them in any type of
format. Are either of the field values ever Null?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Work Days 5
Data Type mismatch Criteria Expression 17
Networkdays in Access 2
dhCountWorkdaysA help 2
Business Days 4
COUNT DISTINCT problem 6
Create a record where one doesn't exist 1
SQL keeps getting deleted!??? 2

Top