Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to determine the First/Last day of a week
Using Functions in Queries
This function returns the First, Last or any specified Day of the week as a date value.
In a blank column in the query insert:
FirstDayofWeek
[DateField] - Weekday([DateField]))+ 1
for the first day of the week or:
LastDayofWeek[DateField] - Weekday([DateField])) + 7
for the last day of the week.
For any other day, just change the integer with the intger value that reprsents the weekday you are looking for.
In a blank column in the query insert:
FirstDayofWeek
[DateField] - Weekday([DateField]))+ 1 for the first day of the week or:
LastDayofWeek
[DateField] - Weekday([DateField])) + 7for the last day of the week.
For any other day, just change the integer with the intger value that reprsents the weekday you are looking for.