Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Week Function
Message
De
16/12/2008 09:58:56
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01367670
Message ID:
01367869
Vues:
10
>>>>Hi
>>>>
>>>>
>>>>WEEK(DATE(2008,12,29)) returns 1.. Does anyone has dealing with that? How to solve?
>>>>
>>>>TIA
>>>
>>>Interesting behavior found when I tried a few things. It seems that SET FWEEK is ignored by the WEEK function but,
>>>
>>>
>>>?WEEK({^2008/12/29},3) && returns 52
>>>
>>>but
>>>SET FWEEK TO 3
>>>?WEEK({^2008/12/29}) && Returns 1
>>>
>Read the help file about the secondf argument to the week function adn you will see that you can control what is concidered tthe first week of the year and therefore what week 12/29 fals in.
? WEEK({^2008-12-28},2)
brought me 53 (what sounds logical to me)... but I'm a little affraid if in others years I'll reach others behaviors... But, anyway... This is what may I use from now own...

tks Jim
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform