Displaying week as date rather than week number

  • Thread starter Thread starter Michael Bentfeld
  • Start date Start date
M

Michael Bentfeld

I currently have a report that groups records by week.
Currently, the group header for each week shows each week
as the number of the week in the year. For example, the
week of 9/22/03-9/28/03 is given as week 39. Is there a
way I can format the group header to show the week covered
using the dates instead of the week number, so that the
report would be easier to understand?
 
Please post the SQL String (of the Query) which is being used as the
RecordSource for the Report.
 
Is there a
way I can format the group header to show the week covered
using the dates instead of the week number, so that the
report would be easier to understand?
Click to expand...

You might try setting the Control Source of a textbox to

"Week Of " & Format(DateAdd("ww", [WeekNo], DateSerial(Year(Date()),
1, 1), "mm/dd/yyyy-") & Format(DateAdd("ww", [WeekNo] + 1,
DateSerial(Year(Date()), 1, 1) - 1, "mm/dd/yyyy")
 
Back
Top