Current Week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I select all the days in the current week from a date field? I want
to view all the employees hired in the current week using the hire date. I
do not want to enter the beginning and ending date of the week each time; I
want the query to look at todays date, look at what the week of the year
todays date is and then include all the hire dates that are included in the
current week.

Thanks,

Scott
 
The Weekday() function returns the numerical day of the week. Hence, on any
day you can get back to Sunday by saying Date() - Weekday(Date()) + 1. That
is: Today - the weekday function (which will return you to last Saturday) + 1
(to advance to Sunday).

HTH
 
That's cool, thank you!

OfficeDev18 via AccessMonster.com said:
The Weekday() function returns the numerical day of the week. Hence, on any
day you can get back to Sunday by saying Date() - Weekday(Date()) + 1. That
is: Today - the weekday function (which will return you to last Saturday) + 1
(to advance to Sunday).

HTH
Click to expand...
 
Back
Top