General information
Category:
Coding, syntax & commands
>>>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
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