5 Business Days...

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
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
 
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.
 
Back
Top