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