Date calculation

  • Thread starter Thread starter Business analyst williams
  • Start date Start date
B

Business analyst williams

How do I create a querie where I can pull a date range 10 business days past
the entered date.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...e984e6c270&dg=microsoft.public.access.queries
 
If there are exactly 5 business days in your week then this is simple.

Between [EnteredDate] And DateAdd("d",14,[EnteredDate])

If you need to worry about Holidays and your have more or less than 5 workdays
per week, you will need to use a vba function for the calculation or a
calendar table with all the dates in the range and added columns to identify
workdays, holidays, etc.



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top