Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of Weeks
Message
From
15/11/1999 17:25:58
 
 
To
15/11/1999 12:55:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00290989
Message ID:
00291311
Views:
40
>>>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
Map
View

Click here to load this message in the networking platform