Weekend and holiday dates only

  • Thread starter Thread starter CMM
  • Start date Start date
C

CMM

What's the best way to query data based on weekends and holidays dates only?
 
For holidays, your only real choice is to have a table of holiday dates, and
join that to your existing table.

For weekends, you could use WHERE Weekday(MyDateField) IN (1, 7)
 
Is the MyDateField where I put a to and from date? For example, I want to run
the query from 11/01/07 through 11/30/07. Also, do I extend the IN (1,7) to
IN (1,7,8,14,15,21,22,29)? An example would be great if available. Thank you
again!
 
MyDateField would be the name of the date field in your table.

Weekday returns number 1 through 7 for Sunday through Saturday respectively.

You'd want

WHERE Weekday(MyDateField) IN (1, 7)
AND MyDateField BETWEEN #11/01/2007# AND #11/30/2007#
 
You must log in or register to reply here.

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

difference in dates 0
can you limit date calculations to exclude weekend dates? 4
Creating a due date but exclude Bank holidays and weekends 3
Calculate between two dates 3
Easter! 7
Is this Possible? - Working Days 4
Conditional formatting excluding weekends and holidays 1
WORKDAY and holidays 7

Back
Top