The last day of the previous week query

B

Bre-x

Hi,

How do I get the first and last day of the previous week?

I seen current week, but nothing about previous week

The last day of the current week:
Date() - WeekDay(Date()) + 7

Regards,

John
 
D

Douglas J Steele

Wouldn't the last day of the previous week be 7 days before the last day of
the current week? In other words,

Date() - WeekDay(Date())
 
J

John Spencer

Assumption: Saturday is the LAST day and Sunday is the FIRST day.

Last day of previous week:
Date() - Weekday(Date())

First Day of previous week:
Date() - Weekday(Date())-6
 
Top