The last day of the previous week query

  • Thread starter Thread starter Bre-x
  • Start date Start date
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
 
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())
 
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
 
You must log in or register to reply here.

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

Spam 4
DateSerial formula help 4
Access Property sheet data missing also syntax 0
week numbers 3
Outlook Outlook To-Do Bar Not Showing 7-days Appointments 0
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
setting first day of the week 1
How to display and store current Week Ending Date (Saturday's) 2

Back
Top