Group by week

M

Mark Koopman

In my report, I am grouping by week. How can I change
the group header from the week number to a date range
("August 3 - August 9, 2003")?? Any help would be great.
 
D

Duane Hookom

To get the week starting date (Sunday)
DateAdd("ww", [WeekNum] ,#1/1/2003#)-Weekday(#1/1/2003#)+1
add 6 more days to get the Saturday
DateAdd("ww", [WeekNum] ,#1/1/2003#)-Weekday(#1/1/2003#)+7
You could combine these expressions with Format(...) etc.
 
Top