I want to submit that the Tuesday Following Date should be used to find Tuesdayday following Wednesday to Saturday
DateField - Weekday(DateField) + 7 + 3 7 takes us to Saturday and three to Tuesday
For Sun to Tuesday DateField - Weekday(DateField) + 3 Minus weekday takes us to Sunday add 3
Kevin Robertson
@Reply 2 years ago
DateField isn't always going to have the same date value so doing any math on Weekday(DateField) could give you any value between 1 and 7.
Ruth MuthogaOP
@Reply 2 years ago
Ruth MuthogaOP
@Reply 2 years ago
Ruth MuthogaOP
@Reply 2 years ago
Here are my screenshots of using
D - Weekday(D) + 7 + 3 - I will land on 7/9 as next Tuesday's Date
D - Weekday(D,4) + 3 Today being July 6, for Sun, June 30, to Tuesday to July 3, all the date set for past Tuesday July 2.
Is there another way to find next Tuesday's date other than :D - Weekday(D) + 7 + 3
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 28.
