Filter for Work Week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I need to skip Saturday and Sunday when it runs. So when
I run it on Monday, it picks up Friday's data. On Tuesday it will pick up
Monday's data. Any idea how this can be done by VB or with criteria?
 
I think you are asking us to help you modify a criteria that we can't see.
Would you share your current SQL view of your query?
 
Use the dayofweek function and an iif statement as criteria.

iif(dayofweek[your date] = 2, [your date] -3,[your date]-1)
 
Back
Top