Title of report to show Previous Week with dates 1

[Pete271]

Hi

I'm using CR8.5 and an access database.

I have a report that will be run once a week to show completed meeting contact reports.

I would like the heading to show

"Reports for last week dd/mm/yyyy to dd/mm/yyyy"

Naturally, I don't want to amend the report every week to make sure that the heading is accurate. Is it possible to automate this?

Many thanks
Peter

 

[beltmanjr]

take the following which will work if the report is run today for last week till now

"Reports for last week " & totext(dateadd("d",-7,currentdate()),'dd-MM-yyyy') & " to " & totext(currentdate(),'dd-MM-yyyy')

using day (d) in date add.

 

[lbass]

If the reports are for the last full week, you can use:

"Reports for Last Week: "+
totext(minimum(lastfullweek),"dd/mm/yyyy")+" to "+ totext(maximum(lastfullweek),"dd/mm/yyyy")

-LB

 

[Pete271]

many thanks for the suggestion, it led me on to

"Contact Reports for Meetings held last week " +CStr(Minimum(LastFullWeek)) + "-"+ CStr(Maximum(LastFullWeek))

which does the trick.

thanks
Pete

 

[Pete271]

lbass - I didn't see your post before responding to the earlier response.

many thanks for your efforts.