Current Week

[Scott]

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

 

[OfficeDev18 via AccessMonster.com]

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

 

[Scott]

That's cool, thank you!

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