Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weeks worked between two dates
Message
 
 
To
05/12/2007 14:19:38
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01273137
Message ID:
01273379
Views:
14
>>You can calculate a calendar week from any arbitrary date. For example
>>
>>ldSunday = {^2000/01/02}
>>lnWeek = INT((ldDate - ldSunday) / 7) + 1
>>
>
>Yes! That should work very nicely. Thanks again!

Any time.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform