JithuAccess
Member
- Local time
- Today, 13:17
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
In my query I have filtered the date field as:
To filter a week's Data.
Is there any method to filter the Dates Between the Date of Monday and Friday based on the current week.
For Example, Today's date is 20-Apr-2021 and Today is Tuesday. I want to filter the data between 19-Apr-2021 and 23-Apr-2021. So I just need to find what date would be on Monday based on Today's Date then my criteria would be:
Thanks
In my query I have filtered the date field as:
Code:
Between Date() and Date()-7
To filter a week's Data.
Is there any method to filter the Dates Between the Date of Monday and Friday based on the current week.
For Example, Today's date is 20-Apr-2021 and Today is Tuesday. I want to filter the data between 19-Apr-2021 and 23-Apr-2021. So I just need to find what date would be on Monday based on Today's Date then my criteria would be:
Code:
Between [Date of Monday] and [Date of Monday + 5]
Thanks