Retrieving Date at start/end of week

[Guest]

I have a report with a grouping level on the week of the year. How would I
get the date at the beginning and end of each week? i.e. If two records I
have contain the dates 11/7/2006 and 11/9/2006, I would want to be able to
get the dates 11/5/2006 and 11/11/2006 as calculated fields which would
pertain to each of those records.

 

[Guest]

You can try using date functions to calcluate the start of the week and end
of the week by trying this.

Given a text box on the form named txtDate with controlsource set to the
value from the record, add a text box named txtWeekStartDate and a text box
named txtWeekEnd date.

Set the control source for txtWeekStartDate to:
=DateValue([txtDate]-Weekday([txtDate])+1)

Set the control source for txtWeekEndDate to:
=DateValue([txtStartDate]+6)

This assumes your week starts on a Sunday and ends 6 days later. You can
adjust the constants according to the dates you want your week start and stop.

Hope this helps...