Grouping by Week Ending? 2

[daguas]

in 8.5. I have setup a group on a date field that will be printed for each week. It displays the first day of that week in the Group header name, I need it to show the week ending date instead. Any ideas?

 

[lbass]

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

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

-LB

 

[daguas]

Your the greatest lbass. thanks much.

 

[Dimst]

to let the count of the week start at monday (counted from the first of january of the year) in stead of sunday add the following behind the formula:

,crfirstjan1,crmonday

so the formula would look like:

totext(dateadd("d",6,{table.date}-dayofweek({table.date})+1),"MM/dd/yyyy", crfirstjan1, crmonday)