Translating Dates into a week of and a grouping header

[egrill]

I need to be able to group date field by week. I can identify the week but I need to translate the ww into a date. For example; if the date falls in the 5th week of the year, I want to group all the dates that fall in week (jan 28 though the Jan 31) all together. Does anyone have work around solution or know what functions I could use in a query or report. I have done with using the Monthname function but can't find a similar function for week of. Thank you

[kepston]

Try this:

Week:[Your_date_field]-Weekday([Your_date_field],1)

Look up the help file for Weekday, to get the correct start day for your week.

[egrill]

Thank you. It worked perfectly.