Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
YEAR() ?
Message
From
08/06/2001 09:56:37
Mark McCasland
Midlothian, Texas, United States
 
 
To
07/06/2001 17:10:05
Robert Etheredge
Visual Solutions, Inc.
Birmingham, Alabama, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: YEAR() ?
Miscellaneous
Thread ID:
00516651
Message ID:
00516878
Views:
7
If you are using VFP 6 you can use Transform():
"Budget Year: " + ;
   IIF(DATE()<= date(YEAR(DATE()), 6, 30), ;
       TRANSFORM(YEAR(DATE())-1) + " - " + TRANSFORM(YEAR(DATE())), ;
       TRANSFORM(YEAR(DATE()))   + " - " + TRANSFORM(YEAR(DATE())+1))
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform