General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only