I'm baffled at the way VFP9 calculates weeks. ie today is 12/14/2010
?date() 12/14/2010 ?date()+11 12/25/2010 ----> week(date()+11) = 52 ?date()+12 12/26/2010 -----> week(date()+12) = 1 ??? ?date()+13 12/27/2010 -----> week(date()+13) = 1 ??? ?date()+17 12/31/2010 -----> week(date()+17) = 1 ??? I need to show week 53 for the dates from Dec 26th to Dec 31st. This has to do with a budgeting system where invoice payment dates should be estimated adding 30 days to the actual invoice issuance date. By using the above functions, the weeks shown above are shifted one week ahead, which is not correct, and it screws up my budgeting system. How can I correct this? Rafael Copquin _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
