Week Start date from a Date MS Access

Question

I have a field with dates, I will like to run a query that updates another field with the Week Start Date (Sunday). How can I do that ? I am using MS Access.

Answer 1

You should be able to do that with a combination of the DateAdd() and Weekday() functions, as in:

UPDATE theTable SET weekStartDate = DateAdd("d", -Weekday(theDate) + 1, theDate)