Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week() of the Month
Message
From
22/01/2003 17:11:05
 
 
To
22/01/2003 16:28:33
Fabian Belo
Independent Developer
Argentina
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00744262
Message ID:
00744522
Views:
9
Fabian,
what am I missing?
if you do
?WEEK(DATE(), 1, 2) - WEEK(DATE(YEAR(DATE()), MONTH(DATE()),1)) +1
it gives you 4
?WEEK(DATE())
also gives you 4


>It will be difficult to find something simpler.... Thank you!
>
>>>Hi all.
>>>VFP 6.0:
>>>
>>>dWeekOfTheMonth=WEEK(dDate, 1, 2) - WEEK(DATE(YEAR(dDate), MONTH(dDate),1)) +1
>>>
>>>
>>>Any suggestions to simplify?
CEILING(DAY(dDate) / 7)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform