Calculate "week-ending" date

G

Guest

In an Access query, I'd like to have an expression that takes the current day
of the week (Sun through Sat) and returns the date for Saturday (in "Short
Date" format) of that same week. Please advise.
 
J

Jeff Boyce

One way to approach this would be to get the day number (Sunday = 1, Monday
= 2, ...) of the current date (Date()), subtract that from 7 (days in a
week), then add that many days to the current date (using DateAdd()
function).

Or have I misunderstood?
 
G

Guest

Thanks so much for the tip...it worked great!!!
--
Thanks!
Mona-ABE


John Ortt said:
Try something allong the lines of:

DateAdd("d",(7-Weekday([DATE])),[DATE])
Click to expand...
 
G

Guest

Thanks so much for the tip...it worked great!!!
--
Thanks!
Mona-ABE


Jeff Boyce said:
One way to approach this would be to get the day number (Sunday = 1, Monday
= 2, ...) of the current date (Date()), subtract that from 7 (days in a
week), then add that many days to the current date (using DateAdd()
function).

Or have I misunderstood?
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

How to count records w/o counting duplicates by week, month, or ye 4
what is the creiteria for month ending Format([Week Ending],"Shor 1
Week ending date query help 1
Previous Week Ending Date 2
Week ending date problems 6
Access: Getting the beginning date of the current week 1
Help to Highlight Excel Row based on Weekly Date Range 2
Request between week ending date 1

Top