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.
Yes... I realized my mistake about 20 minutes after I posted this, that it would only work with two dates that fell in the same year! I guess number of days /7 is gonna be the simplest method.
BOb
Previous
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