General information
Category:
Coding, syntax & commands
>>>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
>>
>>It would be the difference of the weeks...
>>
>>Week( MyDate ) - Week( {^1999.11.1} )
>>
>>BOb
>That works within the year. Between 1/1/2000 and 11/1/2000 (or thereabout) your expression would return a negative number.
If you use an absolute function, the number returned will always be a positive value.
Tom Molloy
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