Solved Current Sunday Day and Current Thurday Day of This Week (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
Assuming today's date is February 8, it is fall in week 6
I want to know the period for this week from Sunday to Thursday?

Current Sunday Day? and Current Thurday Day? of This Week

Query Name: DateQ

This Week is 6
Today: 8/2/2023
This Sudnay:?
This Thursday:?
I tried to make it work via a function DatePart and WeekDay, But I didn't get the right answer
Plz help me

Sample Attached

 

[Ranman256]

=format(date(),"ddd")

or
=format(date(),"w") = vbWednesday

 

[Sarah.M]

=format(date(),"ddd")

or
=format(date(),"w") = vbWednesday

Hi,
I mean I want to know the period of dates for week 6 Start from Sunday end Thursday
For example I want Access to write in my Report this Report is for week 6 Starting from Sunday 5th to Thursday 9th, It changes every week automatically

 

[moke123]

sunday = Date - weekday(Date,1)-1

thursday = Date - (weekday(Date,1)-1)+4

 

[Sarah.M]

sunday = Date - weekday(Date,1)-1

I put +1
And it works
Thanks indeed for ur help