Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
YEAR() ?
Message
 
À
07/06/2001 16:59:45
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Divers
Thread ID:
00516651
Message ID:
00516676
Vues:
15
-SNIP-
>>>VFP 6.0
>>>
>>>"Budget Year: "+IIF(DATE(){06/30/}+YEAR(DATE()), ALLTRIM(STR(YEAR(DATE())-1))+" - "+ALLTRIM(STR(YEAR(DATE()))), ALLTRIM(STR(YEAR(DATE())))+" - "+ALLTRIM(STR(YEAR(DATE())+1)))
>>>
-SNIP-

>>>
>>>Can someone help correct this? I get the error message of Ambiguous Date/DateTime constant. I have the "1-Constants" set as Default (is that good?).
>>>

If you paid attention to the rest of the error message and tried to think for once, then you would had seen your own mistake that {06/30/}+YEAR(DATE()) will not work.

And if you are clueless about what Alex was taking about, then maybe take a look at the help and look at DATE(). If you couldn't already figure out that what you need is DATE(YEAR(DATE()), 6, 30), then please find another day job.

Seriously Chuck, if you actually try it isn't that hard.




Disclaimer: Above message was only to let off some steam. Please ignore if it offend you
- Erik Niese-Petersen

Crazy Dane in USA.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform