Tuesday Following Date - Microsoft Access Expert 28


	Back to Access Expert 28 Comments List

Upload Images Link Email

Tuesday Following Date

Ruth Muthoga

5 months ago

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 5 months 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 Muthoga OP 5 months ago

	Ruth Muthoga OP 5 months ago

	Ruth Muthoga OP 5 months 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

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 28.