Grouping A Date Range

[MrTodd]

I am grouping on a DateTime Field and for each week under grouping options it groups by weeb ok from sunday to saturday but i cant disply the last day of the week for each person ex:

User Work Ordes Closed
Mike Smith
Sun 8/31/03 6
Sun 9/7/03 5

I need to add the end of the week so it looks like this

User
Mike Smith Work Orders Closed
Sun 8/31/03 to Sat 9/6/03 6
Sun 9/7/03 to Sat 9/13/03 5


geting the to end week dont know how to or were the add the date field to the last day of the week in the gouping tried day max but it just gave the max date of each tecks last completed work day in that week

Any Ideas

 

[lbass]

Go to Report->change group expert->select your date group>options->customize group name field->use a formula as group name and enter the following, substituting the datefield you are grouping on for {table.date}:

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

-LB