Calculating Weekdays

[Viv1]

Hi, Please can anyone tell me if there is a simple way to find out the number of working days (Mon-Fri) between 2 dates without having to use a form? I need to know the total working days and would like to be able to include it in the query criteria.

Any help greatly appreciated,
Viv

 

[Golom]

Have a look at faq181-261

 

[Viv1]

Hi, problem is I am not sure what to do with this code and I need to include it in a query. I have the straight forward DatDiff working but this counts all days and I need to take out weekends. Most of the coding examples don't seem suitable for queries.

Thanks, Viv

 

[lespaul]

After putting the code in a module, in your query you put:

SELECT DeltaDays([StDt], [EndDt]), OtherField FROM TableName

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[Viv1]

Thank you, I will give it a go!