Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Report heading showing 2,001.00 instead of 2001?
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Title:
Crystal Report heading showing 2,001.00 instead of 2001?
Miscellaneous
Thread ID:
00620118
Message ID:
00620118
Views:
57
Here's my formula in Crystal. It's the last line of the formula that is in question. I have tried Int() and Truncate() and no help. I still get 2,001.00 as the year in my heading. The parameter ?s_date is a Date value that gets entered as a parameter value such as 10/01/2001. Seems simple enough to me. Do you know what's wrong? Thanks for your help.
StringVar HeadingDate;

If Month({?s_date}) = 01 Then
    HeadingDate := "1st Quarter"
else
If Month({?s_date}) = 04 Then
    HeadingDate := "2nd Quarter"
else
If Month({?s_date}) = 07 Then
    HeadingDate := "3rd Quarter"
else
If Month({?s_date}) = 10 Then
    HeadingDate := "4th Quarter";

HeadingDate + " " + ToText(Year({?s_date}))
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform