07-25-2008, 06:07 AM
Ted, you wrote:
"For instance the 6th day of the year would = 6 \ 7 . So you are in the first week."
Actually, the 6th day of the year is in the second week for 2008.
You're on the right track, but your integer division of the day of the year is missing a key factor, which is: the day of the week (1 to 7) of January 1st of the subject year.
Before integer dividing by 7, you must add the day of the week of Jan 1st, minus 2, to the day of the year of the subject date. After the integer division, you must add one to the result to get the correct week number.
As you can see, this issue gets more and more complicated.
Regards..... Moneo
"For instance the 6th day of the year would = 6 \ 7 . So you are in the first week."
Actually, the 6th day of the year is in the second week for 2008.
You're on the right track, but your integer division of the day of the year is missing a key factor, which is: the day of the week (1 to 7) of January 1st of the subject year.
Before integer dividing by 7, you must add the day of the week of Jan 1st, minus 2, to the day of the year of the subject date. After the integer division, you must add one to the result to get the correct week number.
As you can see, this issue gets more and more complicated.
Regards..... Moneo