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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate two dates 1
Make query to calculate two dates 2
calculate two dates 1
Update Date value to current year 3
Update Query? 5
Calendar Date 4
Date function in a query 2
Years of Employment 2

Back
Top