Date Range on Report

[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

 

[Allen Browne]

Between CDate(Date() - WeekDay(Date()) + 2) And CDate(Date() -
WeekDay(Date()) + 8)

 

[Tim]

I had to modify your expresion slightly, but it led me in
the right direction. Thanks for your help.

Tim