Previous Week Ending Date

[Guest]

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

 

[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

 

[Guest]

That worked, thank you!

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