M
MarieT
I need to make a crosstab query that has, as a column heading, the date of
the beginning of the week in which the date value in the record falls. I know
how to make the heading be a number representing the week of the year by
using: Format(ShipDate, "ww"), but how do I convert the week digit to an
actual Date reprersenting the beginning of the week the date falls in? For
example, if the ShipDate is March 13, 2008, the heading will be: 2008/03/09
assuming Sunday is the beginning of the week. If ShipDate is March 18, 2008
then the heading will be 2008/03/16.
Any help will be greatly appreciated!
MarieT
the beginning of the week in which the date value in the record falls. I know
how to make the heading be a number representing the week of the year by
using: Format(ShipDate, "ww"), but how do I convert the week digit to an
actual Date reprersenting the beginning of the week the date falls in? For
example, if the ShipDate is March 13, 2008, the heading will be: 2008/03/09
assuming Sunday is the beginning of the week. If ShipDate is March 18, 2008
then the heading will be 2008/03/16.
Any help will be greatly appreciated!
MarieT