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 14:03:51
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01052733
Message ID:
01052744
Vues:
11
This message has been marked as the solution to the initial question of the thread.
>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.

try
FUNCTION WYTOD(nYear,nWeek)
RETURN DATE(m.nYear,1,1)-DOW(DATE(m.nYear,1,1),3) + m.nWeek*7
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform