Entries with Date This Week

[Mirjam]

I set up the following code on the Expression Builder
Date() Or Between Date() And Weekday(6) Or <Date()
I want to get all entries of the rest of the week, but it is not working.
Can I set up Weekday(6)?
So if it is Monday i want to see all entries from Monday to Sunday and if it is Wednesday i want to See all entries between Wednesday and Sunday.
Could you please help me! thanks

 

[Jon K]

Try this in the Criteria for the date field:

Between Date() And Date()-Weekday(Date(),2)+7
.

 

[Mirjam]

Thank you for the help, that was great!!!
Now they changed there mind, so they also want to see the entries of this week, which were yesterday for example. So I want to show "this whole week" every day. Do you know how to do that, too?
Thank you
Mirjam

 

[Jon K]

This will return records from Monday to Sunday of the week.

Between Date()-Weekday(Date(),2)+1 And Date()-Weekday(Date(),2)+7
.

 

[Mirjam]

Thank you, that was a fast answer!

This will return records from Monday to Sunday of the week and next. Is that right?
week:Between Date()-Weekday(Date(),2)+1 And Date()-Weekday(Date(),2)+14

 

[Jon K]

Yes,

Between Date()-Weekday(Date(),2)+1 And Date()-Weekday(Date(),2)+14

when put in the criteria for a date field should return records between 12-25 Nov if the query is run this week.
.