Date Restrictor for Last Week

C

ChuckW

Hello,

I run a weekly report for the previous week either on
Monday or Tuesday. I want to run a report that will
capture a Monday to Sunday cycle. It could also be a
Sunday to Saturday cycle as well. Does anyone know what
date restrictor to use?

Thanks,

Chuck
..
 
N

Nikos Yannacopoulos

Chuck,

The following:

DateValue(Now())-Weekday(DateValue(Now()),2)

will return the date for last Sunday. Likewise, the following:

DateValue(Now())-Weekday(DateValue(Now()),3)-7

will return the day for Last week's Monday. Subtracting on from both will
give the Sunday to Saturday cycle.

HTH,
Nikos
 

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

Date Restrictor 3
Date Restrictor for last week's sales 1
Date restrictor for this week 1
Date Restrictor for this week 7
Remote stopped working in PowerPoint Presenter View 0
Week and days query 8
Date Restrictor for last business day 3
Criteria to delete last 3 days of data 8

Top