Date Restrictor for Last Week

  • Thread starter Thread starter ChuckW
  • Start date Start date
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
..
 
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
 
Back
Top