Date Restrictor

[ChuckW]

Hello,

I run a weekly report for the previous week either on
Monday or Tuesday. I want to run a report that will
capture a Monday to Sunday cycle. It could also be a
Sunday to Saturday cycle as well. Does anyone know what
date restrictor to use?

Thanks,

Chuck

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[Michel Walsh]

Hi,




Your post is not appropriate in this newsgoup.


Vanderghast, Access MVP

I am from the Access support department at

http://www.enterpriseprojectconsulting.com and we would be happy to assist
you in resolving your issue.

 

[John Spencer (MVP)]

First day of the week being Monday.

DateAdd("d",2-Weekday(Date()),Date())

To get that back to Monday a week ago subtract 7 and to get to Sunday subtract 1

Between DateAdd("d",2-Weekday(Date()),Date())-7 and
DateAdd("d",2-Weekday(Date()),Date())-1

Adjust the numbers to get Sunday to Saturday (Basically change the 2 to a 1)