By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

Find Sunday and Saturday

P: n/a
Given a selected date, how do I find the date of the Sunday and Saturday of
the week that that date is in?

Thanks!

Jerry
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can use the Weekday function which, by default, returns 1 for Sunday, 2
for Monday and so on up to 7 for Saturday. Knowing which day it is, you can
easily figure out how many days you need to subtract for the previous
Sunday, or add for the following Saturday.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Jerry" <pl****@nospam.forme> wrote in message
news:cS****************@newsread3.news.atl.earthli nk.net...
Given a selected date, how do I find the date of the Sunday and Saturday of the week that that date is in?

Thanks!

Jerry

Nov 13 '05 #2

P: n/a
"Jerry" <pl****@nospam.forme> wrote in
news:cS****************@newsread3.news.atl.earthli nk.net:
Given a selected date, how do I find the date of the Sunday
and Saturday of the week that that date is in?

Thanks!

Jerry

The format() function will return the day of week as a number 1 to
7 when given the "w" option. To get the saturday, use the dateadd()
function to increase the date by the number needed.

It's all in the help files.

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.