Expression for current week

  • Thread starter Thread starter Yasmin Nora
  • Start date Start date
Y

Yasmin Nora

Would like to know the expression to use in an Access
query to run a weekly report that will display data for
only the 5 business days of the current week. Thanks
 
Not all weeks have 5 business days! You have to build a table of holidays and
include that table in you expression to exclude any holidays that fall in the
current week.
 
Would like to know the expression to use in an Access
query to run a weekly report that will display data for
only the 5 business days of the current week. Thanks
Click to expand...

Bearing in mind PC Datasheet's cogent suggestion about holidays,
here's an expression that returns the range from the most recent
Monday to the next Friday:
= DateAdd("d", 1 - DatePart("w", Date(), vbMonday), Date())
Click to expand...
AND <= DateAdd("d", 5 - DatePart("w", Date(), vbMonday), Date())

If the query is run on a weekend it will return the previous week.
 
Back
Top