Customize Group Name for Date Group 1

[mychal]

In CR 8.5, I'm grouping by a date field and printing the section for every two weeks.

How can I customize the group name so that I show the date range as the group name?

Gracias

 

[mychal]

...instead of just the first date in the range?

 

[lbass]

Go to report->change group expert->date group->options->customize group name field->use a formula as group name->x+2 and enter:

totext({table.date}-dayofweek({table.date}) + 1,"MM/dd/yyyy") + " - " + totext({table.date}-dayofweek({table.date}) + 7,"MM/dd/yyyy")

-LB

 

[mychal]

One star for you. Close, but not perfect. The last string should be + 14.

 

[lbass]

Sorry, didn't read your post closely enough--thought it was for one week.

-LB