Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
YEAR() ?
Message
 
To
07/06/2001 16:59:45
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00516651
Message ID:
00516676
Views:
14
-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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform