Crystal XI - Group by Week - Display SUNDAY Date
Posted on 2009-02-19
I have a report that is grouping by week date but is displaying the first data point date in the group header.
First data date is Wednesday, February 18, 2009 and the Group Header is displaying "Week of: February 18, 2009"
I am trying to get the report to display in the GroupHeaderName the Sunday Date since we use a Sunday-Saturday week. with this my date would display as follows:
Week of February 15, 2009
Data Date 1 - Wednesday, February 18, 2009
Data Date 2 - Wednesday, February 19, 2009
Week of February 22, 2009
Data Date 3 - Tuesday, February 24, 2009