Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week Function
Message
 
 
To
16/12/2008 10:15:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01367670
Message ID:
01367902
Views:
10
I would handle it this way
ldDate = {^2008-12-28}
...
lnWeek = WEEK(ldDate,1)
IF lnWeek = 1 AND MONTH(ldDate) = 12
	lnWeek = WEEK(ldDate-7,1) + 1
ENDIF	

? lnWeek 
>How did you get exactly the value of year 2012 I mean.. did you try all 31 days untill there or has follow any other logic?
>
>to deal with that I just see
>
>
IF  lnweek = 1 AND lnmes>11
>     lnweek			= 53
>endif
>
>sounds not smart.. but??
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform