-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.