Week numbers problem.

[harwooddale]

Hi,
I have a table that contains current week info and that works just fine.
We are going to amend the table so that each row contains summary data from the previous 12 weeks.
This is fine when I am doing an insert where the previous 12 weeks are in the same year.
What do I do if some or all of the previous 12 weeks are in the previous year?

Help Gratefully Appreciated.

James Boak

 

[sem]

Why does it matter? I can not see any difference between weeks being in this or previous year.

Regards, Dima

 

[harwooddale]

The week numbers will go from 1 in the current year to 52 in the previous year.

 

[sem]

So what? You may get date difference by subtracting dates, not week numbers.

Regards, Dima