Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Week of month
Message
De
17/09/2004 10:55:40
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
17/09/2004 10:50:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00943365
Message ID:
00943392
Vues:
17
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform