Calculate Week Days Difference

[CliffSP]

Hi all

What expression can I use to calculate the difference between 2 dates, but excluding weekends. i.e. A helpdesk call was logged on Thursday and closed on Tuesday. I want the answer to be 2 days and not 4 (as in including Saturday & Sunday).

TIA


Cliff

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=288194

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CliffSP]

Thanks PHV - I've looked at that code and pasted it into a new module, but when I run my query:

CallAge: DateDiffW("d",[Date Opened],[Date Closed])

I get this error message:

Undefined Function 'DateDiffW' in expression.

Where should I have pasted that code?

TIA

Cliff

 

[RoyVidar]

It needs to be a standard module, not a form/reports module (i e, in VBE - Insert | Module) - and - name the module something other than the function name.

If you wish to exclude also hollidays (i e return only workdays), have a look at MichaelRed's faq faq181-261.

Roy-Vidar

 

[CliffSP]

Many thanks guys - all sorted.

 

[MichaelRed]

there is also a faq on his site ...




MichaelRed