Grouping by dates

[DannyBill]

Using CR9

I'm using {EndDate} as a field to group by, and a parameter field to select the date range for record selection. Currently the report is displaying the first day in the week (Sunday), how do you get the report to display the date for that following friday thus being the last work day for that piticular week.

Thanks for all the help you guys have given me on this report. I'm finding working with dates are my weak point.

Thanks again,

Dan

 

[lbass]

Go to report->group expert->options->customize groupname->use a formula to customize name->x+2 and enter:

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

-LB

 

[DannyBill]

that worked....thanks!!!