Inserting Date Range in Header or Title 1

[rji1124]

Hi... I was wondering how I can insert a date range in a header or title... I have a report that will run every Monday (or Tuesday if Mon is a holiday) and the report extracts data using LASTFULLWEEK... we report on all changes that were implemented from Sun to Sat in the previous week.

I would like the header or title to have a line that looks like:

Period Covered: Sunday 6/15/2003 to Saturday 6/21/2003

Any help will be much appreciated...

Thanks

 

[synapsevampire]

Try:

"Period Covered: " + totext(minimum(lastfullweek),"dddd MM/dd/yyyy&quot + " to " +totext(maximum(lastfullweek),"dddd MM/dd/yyyy&quot

-k

 

[rji1124]

Worked perfectly! Thanks... you have saved me hours of trial and error....