Sage 100

In Crystal Reports 2011, I am grouping by a Transaction Date, using ""The section will be printed: for each week"" functionality. Works well, breaks my report into proper groupings. However, in my Group Footer and Header, I want the Group Name to be the LAST date of the week, and not the FIRST Date of the week. How can I change this?

In the group options, select Customize Group Name Field| Use Formula as Group Name. The formula I use looks like: totext(dateadd(""d"",6,{AR_InvoiceHistoryHeader.InvoiceDate}))

That was exactly what I was looking for...