Access Criteria for Current Week starting Monday and ends Sunday

[shrut999]

[FONT=verdana, geneva, lucida, lucida grande, arial, helvetica, sans-serif]Good evening everyone,[/FONT]

[FONT=verdana, geneva, lucida, lucida grande, arial, helvetica, sans-serif]I have the formula below but it does Sunday to Saturday. Is there a way I can get a criteria which can do current week starting Monday and ends Sunday, I searched a lot but can't find an correct answer. Any help will be greatly appreciated. Thank you very very much in advance.

[/FONT]

[FONT=verdana, geneva, lucida, lucida grande, arial, helvetica, sans-serif]"BETWEEN [/FONT]DateAdd("d", -((Weekday(Date()) - 1)), Date()) AND Date()"

 

[alansidman]

This link will show how to change Weekday function

MS Access: Weekday Function

 

[shrut999]

This link will show how to change Weekday function

MS Access: Weekday Function

I tried it but its not giving me the results.

 

[shrut999]

If I change the 1 to 2 it is pulling information from Monday to today but its not including Sunday.
Which means BETWEEN DateAdd("d", -((Weekday(Date()) - 2)), Date()) AND Date()

Is it because its not Sunday yet?

 

[alansidman]

the Term Date() in Access means today so that is why. You will need to adapt your expression.

 

[shrut999]

After few hours of playing around I got it Includes data from This week starting Monday to Sunday

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