The # of workdays between dates for a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I be able to count the number of work days between two dates in a
new field in a query?
 
Hi Alex,

One of the way is to write a method/function in a module and call
that in your query. For e.g., if you write a method
GetNumberOfWorkdays(Date1,Date2) that could return a numer then you can
have your query like

Select ColA, ColB, GetNumberOfWorkdays(datefield1, datefield2) as
NumberOfWorkDays from table ...

I am not sure whether there is a built-in function available to do
this task.

Cheers,
Saran.
 
Back
Top