Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week of month
Message
From
17/09/2004 10:35:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/09/2004 10:30:50
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00943365
Message ID:
00943371
Views:
13
This message has been marked as the solution to the initial question of the thread.
>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
Ç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
Next
Reply
Map
View

Click here to load this message in the networking platform