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.comWould you believe Far Side Lite?
More than 270 original cartoons.