Date Criteria clarification

[pbaldy]

it came back with the dates 1/7/2017 (Mon) to 1/13/2013 (Sat) next week's dates.

I assume you mean Sunday, since the 7th is Sunday. Sounds like it's working correctly.

[djclinton15]

Damn, no such luck. My 2-formulas above doesn't work when current date changes. Obviously, I just don't get it & should jut give it up!

[pbaldy]

Can you attach the db here? They still return the expected dates for me:

?date() - Weekday(date()) + 8
1/7/2018
?date() + (14 - Weekday(date()))
1/13/2018

[ssanfu]

This is my test dB:

[djclinton15]

Steve, I extend my great appreciation for you taking the time & sending 'test_Mon2Sun' dbs. It's sort of what I'm looking for except (I should have mentioned) I need all 7-weekdays, "Sat" & "Sun." Your 'test_Mon2Sun' dbs Just run "Mon" thru "Fri." Might you be willing to revised & send back your 'test_Mon2Sun' dbs including "Sat" & "Sun?"

I would really be grateful if you could! Thanks.

[djclinton15]

Steve, I extend my great appreciation for you taking the time & sending 'test_Mon2Sun' dbs. It's sort of what I'm looking for except (I should have mentioned) I need all 7-weekdays, "Sat" & "Sun." Your 'test_Mon2Sun' dbs Just run "Mon" thru "Fri." Might you be willing to revised & send back your 'test_Mon2Sun' dbs including "Sat" & "Sun?"

I would really be grateful if you could! Thanks.

Oh and Steve, I need the weekdays starting with "

Mon

" thru "Sun".

[ArviLaanemets]

Tried you the syntax I adviced?

Date() - (Weekday(Date(),2) -1)

to return Monday of current week.

To get the query to return data from MyDate (without time part) interval from current ISO week:

 ... WHERE MyDate Between (Date() - (Weekday(Date(),2) -1)) AND (Date() - (Weekday(Date(),2) -1) +6)

Edit. When MyDate includes date AND time, then :
1. when there never are MyDate values at midnight, you can use the WHERE clause as

 ... WHERE MyDate Between (Date() - (Weekday(Date(),2) -1)) AND (Date() - (Weekday(Date(),2) -1) +7)

;
2. Most general way which work always, will be:

 ... WHERE MyDate >= (Date() - (Weekday(Date(),2) -1)) AND MyDate < (Date() - (Weekday(Date(),2) -1) +7)

[ssanfu]

Steve, I extend my great appreciation for you taking the time & sending 'test_Mon2Sun' dbs. It's sort of what I'm looking for except (I should have mentioned) I need all 7-weekdays, "Sat" & "Sun." Your 'test_Mon2Sun' dbs Just run "Mon" thru "Fri." Might you be willing to revised & send back your 'test_Mon2Sun' dbs including "Sat" & "Sun?"

OK, I did/have not change any code in the two date functions.

However, I added conditional formatting, changed the names of the subforms and did some general cleanup.

In the first dB, I only added a few dates for a couple of months for testing. I was only testing the functions.
In this dB, I added dates from 11/1/2017 to 2/28/2018. (using the code in Module 2)

Is this what you are looking for?

[djclinton15]

Steve, once again thanks very much for your time with me. One issue with the NextWeek Form you have starting from Sunday and ending on the following Sunday. Whereas, I wanted NextWeek's starting from next Monday and ending on the following Saturday. I.E. 1/8/2018 to 1/14/2018.

In the qryNextWeek you have: Between fWeekStartMonday(Date()+7) And fWeekEndSunday(Date()+7)

I tried making some changes, but had no luckBetween fWeekStartMonday(Date()+7) AndfWeekEndSaturday(Date()+6)

Again, can you tell me what changes need to make in order to have NextWeek's form starting from next Monday and ending on the following Saturday?

[ssanfu]

In your Post #1, you say

However I would like my weekday’s query to start from Monday and end on Sunday.

Post #20 :

It's sort of what I'm looking for except (I should have mentioned) I need all 7-weekdays, "Sat" & "Sun."

Post #21:

Oh and Steve, I need the weekdays starting with "

Mon

" thru "Sun".

Post #24:

One issue with the NextWeek Form you have starting from Sunday and ending on the following Sunday. Whereas, I wanted NextWeek's starting from next Monday and ending on the following Saturday. I.E. 1/8/2018 to 1/14/2018.

OK, I'm totally lost. You keep saying you want from MONDAY through SUNDAY.
Then you give a date example 1/8/2018 to 1/14/2018.
MONDAY is 1/8/2018 (on my calendar) and the following SUNDAY is 1/14/2018 (on my calendar)!!



Since today is 1/6/2018 (Jan 6th):
Last Week was 12/25/2017 (Monday) through 12/31/2017 (Sunday)
This Week is 1/1/2018 (Monday) through 1/7/2018 (Sunday)
Next Week will be 1/8/2018 (Monday) through 1/14/2018 (Sunday).

Not sure what I am missing.

Again, can you tell me what changes need to make in order to have NextWeek's form starting from next Monday and ending on the following Saturday?

Are you now wanting Monday through ** Saturday **?
If so, just for Next Week? Or for Last, This AND Next weeks?

[djclinton15]

Steve, I'm sincerely sorry for such confusion. I was quite confused myself juggling between 2-separate dbs. In 1-dbs I needed a current week form & next week form both having the weekdays starting from Monday and ending on Sunday. Simultaneously, I also was working on a 2nd-dbs where I needed a current week form & next week form both having the weekdays starting from Sunday and ending on Saturday. I know how ludicrous it must sound, but actually is true. Needless to say, I had my head up my a**! With your help (along with others here) I think I have it all sorted out much thanks to the members here.

[ssanfu]

No problems..... glad you figured it out.


So this is a pic of you??
I always wondered who it was........