Hi you all,
I haven't seen this earlier. The rule of numbering weeks is very simple and is an ISO standard. Unfortunatly there are some traditional numberings which will confuse. I have the same problem but for priority reasons I didn't work for a complete solution.
Look at my
thread to understand how weeks are numbered following ISO rules which are used in western europe and the format date/time function which follows the traditional american rules. Unfortunatly they are so incompatible that there is no simple solution to get the ISO week number from the format date/time function.
BTW using the ISO standard forced Germany to change the law to make Monday the first day of the week.
Waldemar
Waldemar
Using 7.1.1, 8.5.1, 8.6.1, 2009 on XP and RT
Don't forget to give Kudos to good answers and/or questions