Previous Week Ending Date

S

Scott

I use the following in a query to get the current week ending date (today is
10/30/06 and the query field returns 11/04/06):
DateAdd("d",7-Weekday(Date()),Date()). What is the syntax to get the
previous week ending date (with today's date of 10/30/06 I want it to return
10/28/06)?

Thank you,

Scott
 
J

Jeff Boyce

Scott

This isn't very elegant, more a brute force kludge, but if you already have
a way to get this week's EndOfWeek, couldn't you just subtract 7?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

Scott

That worked, thank you!

Jeff Boyce said:
Scott

This isn't very elegant, more a brute force kludge, but if you already have
a way to get this week's EndOfWeek, couldn't you just subtract 7?

Regards

Jeff Boyce
Microsoft Office/Access MVP
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

Week ending date problems 6
Week starts on Friday 3
Min/Max Dates and Group By 2
Date Expression 9
Sequential values in access table 0
Taking the sum between two dates 2
Date Brackets as an IIf statement 3
Calculating a week ending date 6

Top