General information
Category:
Coding, syntax & commands
Bob,
If you calculate usung the actual dates with the latter date first, you can divide bt seven and get yhe number of weeks. You will be able to span years.
Tom Molloy
>>>>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
>
>Yep... but, there was a flaw in my logi, since weeks is the number of weeks from the beginning of the year, this will only work with two dates that fall in the same year.
>
>Woe is me. Number of Days / 7 is the best way to do it.
>
>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