Find the Date of Monday Based on Current Date (1 Viewer)

JithuAccess

Member
Local time
Yesterday, 23:17
Joined
Mar 3, 2020
Messages
297
Hello Guys,

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
 

Minty

AWF VIP
Local time
Today, 06:17
Joined
Jul 26, 2013
Messages
9,363
Is it always the Monday before the current date?
e.g. This month from the 19th until 25th you would want

Between 2021-04-19 And 2021-04-23

As your criteria?
 

JithuAccess

Member
Local time
Yesterday, 23:17
Joined
Mar 3, 2020
Messages
297
Is it always the Monday before the current date?
e.g. This month from the 19th until 25th you would want

Between 2021-04-19 And 2021-04-23

As your criteria?
Yes it is.

Thanks
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:17
Joined
Oct 29, 2018
Messages
19,134
Hi. To get the Monday of the current week, you could try something like:
Code:
DateAdd("d", 1-Weekday(Date(), 2), Date())
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 01:17
Joined
Feb 19, 2002
Messages
36,837
Here's a database with useful date functions.
 

Attachments

  • UsefulDateFunctions20201124b.zip
    300.2 KB · Views: 442

Users who are viewing this thread

Top Bottom