A
Art Vandaley
Hi,
(Access 2007)
I have a problem with my query which shows week numbers on a column. Week
numbers derived from date field of table. Column has below string:
WEEK: Format$([Table1].[Date1];'ww')
Above equation gives next week number for Sundays. On my computer date
system is normally adjusted to start the new week number on Mondays.
At the other hand I have a string calculating week number for my form like:
WEEK.Value = Format(Date1.Value, "ww", vbMonday, vbFirstFourDays)
Above formula gives correct result. For example:
24th. February 2008 ==> My form gives 8 and my query gives 9 for week
number. Actually, both should give result of 8
Does anybody have an idea?
PS. Wayne's method did not work.
Best Regards.
(Access 2007)
I have a problem with my query which shows week numbers on a column. Week
numbers derived from date field of table. Column has below string:
WEEK: Format$([Table1].[Date1];'ww')
Above equation gives next week number for Sundays. On my computer date
system is normally adjusted to start the new week number on Mondays.
At the other hand I have a string calculating week number for my form like:
WEEK.Value = Format(Date1.Value, "ww", vbMonday, vbFirstFourDays)
Above formula gives correct result. For example:
24th. February 2008 ==> My form gives 8 and my query gives 9 for week
number. Actually, both should give result of 8
Does anybody have an idea?
PS. Wayne's method did not work.
Best Regards.