Queries - Date

[Tim]

Hi there,

How to exclude weekends/holidays when calculating the
numbers of days within a certain period (or within
business day)?

Thanks.

Tim

 

[Rod]

-----Original Message-----
Hi there,

How to exclude weekends/holidays when calculating the
numbers of days within a certain period (or within
business day)?

Thanks.

Tim
.
Did somebody help on you? If yes, can email how?

Thanks

Rod

 

[Dennis Schmidt]

Hi Tim,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

This Knowledge Base article should get you started in the right direction:

How to Determine Number of Working Days Between Two Dates

http://support.microsoft.com/default.aspx?scid=kb;en-us;97757

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Van T. Dinh]

Try The Access Web article:

<http://www.mvps.org/access/datetime/date0006.htm>

HTH
Van T. Dinh
MVP (Access)