5 Business Days...

S

Steven M. Britton

I would like to run query that has the criteria of 5
Business days. Now not to get to fancy right now to
include holidays, we can just work it from Monday to
Friday. I currently run Between Date() and Date()-5, but
this is just 5 calendar days... Is there something built
in or a way to do this?

-Steve
 
P

PC Datasheet

I would add another field called CalculatedWeekNum to your query that looks at
your date field and calculates the week number of that date. Next I would set
the criteria for that field to limit it to the week you want. Finally I would
set the criteria of your date field to Between Monday and Friday of the
CalculatedWeekNum field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Page numbering with Merged Document and IF statements 1
Finding the right style field in VBA 0
Search closest day in the past from today 2
Need calendar form to display holidays 1
Finding the proper style field and the numbered paragraph value within the style 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
number of months and days between two dates without approximation 3

Top