Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week of month
Message
From
17/09/2004 10:55:40
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/09/2004 10:50:10
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00943365
Message ID:
00943392
Views:
18
>>>Hi all,
>>>
>>>Is there a quick way to get the week of month given a date?
>>>
>>>example.
>>>sep 04
>>>s   m   t   w   t   f   s
>>>            1   2   3   4 - week 1
>>>5   6   7   8   9  10  11 - week 2
>>>12 13  14  15  16  17  18 - week 3
>>>19 20  21  22 ....        - ...
>>>oct 04
>>>                    1   2 - week 1
>>>3   4   5   6   7   8   9 - week 2
>>>...
>>>
>>week()
>>To be more clear:
>>?Week(ldDate)-Week(Date(Year(ldDate),Month(ldDate),1))+1
>>Cetin
>
>Thank you. The formula works.

Ramil,
But test it first well I didn't. Near year changes (end of Dec or start of Jan) you might get unpredictable values.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform