>>
>>With all due respect, it seems to me that this is a problem that hasn't occurred yet.
>>
>>I've been in this business for 22 years. If I can offer one piece of advice to you it would be, "Don't try to solve problems that haven't occurred". You're doing both yourself and your users a big help if you follow the above.
>
>George,
>
>Thank you for your advice. I agree with you.
Dmitry,
One other thing that I thought of regarding this problem.
The eventual solution would also depend on a number of factors. Are we talking about a fiscal months/years? If so, then a table based solution might be the most appropriate. If it's a calendar year, does the first week include January 1st, or the first complete week?
George
Ubi caritas et amor, deus ibi est