Well, I said that you might have to use something like my SUB to figure the day of the week the First is. Do I have to do the entire project?
Using the first day of year week day can tell you the end of the last week also using integer division. You can MOD 7 to calculate how many days after the last week ending the actual date is.
Let me guess, you already figured it out, didn't you? LOL
I guess that is why it is a challenge..................but I recall you posting about this when you did not have it figured out.
Too busy now. I know you can do this Moneo.
Ted
Using the first day of year week day can tell you the end of the last week also using integer division. You can MOD 7 to calculate how many days after the last week ending the actual date is.
Let me guess, you already figured it out, didn't you? LOL
I guess that is why it is a challenge..................but I recall you posting about this when you did not have it figured out.
Too busy now. I know you can do this Moneo.
Ted
Get my QB demonstrator here: http://dl.dropbox.com/u/8440706/Q-Basics.zip