Sometimes you look at a problem too hard ;-)
>>Hi Michelle,
>>
>>What's wrong with INT((DATE()-{^1999-11-01})/7)?
>>
>>
>>>Can anyone think of a formula or fast piece of code (I plan on running it from a SELECT) that can tell me the number of weeks since 11/1/99? I'm thinking some combination of the year and WEEK() might do it, but I haven't come up with anything.
>>>
>>>Thanks,
>>>
>>>Michelle
>
>
>Hmmm... Didn't think of dividing the days by 7. :) I'll try that.
>
>Thanks, both of you.
>
>Michelle
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05