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
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