Group by week

  • Thread starter Thread starter Mark Koopman
  • Start date Start date
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.
 
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.
 
Back
Top