Date Range on Report

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a report that is printed weekly. I would like to
include a date range on the report that corresponds to
Monday through Sunday of the week it is printed. For
example, if I printed the report today it would display
October 6, 2003 - October 12, 2003. If I printed the
report next week it would display October 13, 2003 -
October 19, 2003. How can I do this?

Thanks,
Tim
 
Between CDate(Date() - WeekDay(Date()) + 2) And CDate(Date() -
WeekDay(Date()) + 8)
 
I had to modify your expresion slightly, but it led me in
the right direction. Thanks for your help.

Tim
 
Back
Top