count workdays

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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?
 
Back
Top