format week date

[was1]

I've been searching thru all the threads and I'm getting myself confused.

I'm trying to create a "week-ending" date for any returned items. My week begins on a monday and ends on a sunday.

For example, an item is returned on 6/24 (wed). My return date is 6/24 and I want to create a week-end date of 6/28.

Later I will be creating a report based on the week-end date of how many items were returned within that week.

Any help would be greatly appreciated.

thanks!

 

[PHV]

WeekEnding: [yourDateField]+8-Weekday([yourDateField],1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[was1]

WooHoo!! It worked!!! Thank you!!! I was missing the 1.

 

[was1]

That worked great but now I'm running into another problem.
When I get to the end of the month, I would like the week end date to be the month end date.

ex: 6/30/09

week end date should be 6/30/09 and not 7/05/09.