DateAdd not working correctly. Need fast help!!

B

Ben

I have a query with the following field:
DateAdd("d",1-Weekday([Start_Date]),[Start_Date])

What is need it to do is calculate all the items between Monday and Friday
based on Monday's Date. So, if there are 10 sites in the list between Monday
and friday, I want to display those 10 sites with Monday's Date as the column
header. The header also needs to come in Medium Date Format.

Any help would be appreciated.

Thank you,
Ben
 
J

John Spencer

It's working. It's not working the way you want it to. Try this variation.
Note the additional argument in the Weekday function - it now uses MONDAY (2)
as the first day of the week instead of the default of Sunday (1).

DateAdd("d",1-Weekday(Start_Date,2),Start_Date)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Top