Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need function to find Monday by Week No
Message
De
24/09/2005 13:45:50
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01052733
Message ID:
01052739
Vues:
10
>Similar how VFP has function WEEK(), I need to find a reverse: Date (Monday) of the week by Week number (where Week Number is from 1 to 52).
>I actually have a function like that but it is so long I am embarrassed to show it here (it consists of 19 lines) <g>.
>
>I was wondering if anybody can recommend a short and fast (speed is the most important) function to do this.
>
>Thank you in advance.

Dmitry,

It's not that hard to find the first monday of the year (date(year,1,1), find out the dow, and add a number depending on dow() to get to the first monday)

From there, add 7 * (weeknumber - 1)
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform