Year formatting is wrong in ActiveX viewer

[ctwilliams]

I have a formula @GroupDate:

If {LaborForecast.FixedFee} then
Date({LaborForecast.BillingDate})
else
Date({LaborForecast.StartDate})

And I have a formula @FormatDate:

select {?Sort By}
case "Month/StartDate" : MonthName(Month({@GroupDate})) & " " & year({@GroupDate})
case "Month/Customer/StartDate" : MonthName(Month({@GroupDate})) & " " & year({@GroupDate})
case "Month/Resource/StartDate" : MonthName(Month({@GroupDate})) & " " & year({@GroupDate})
default: " "

I am grouping my report by @GroupDate, but am displaying @FormatDate as the label in the Group Header. In the Crystal Reports client this works beautifully, eg. the Group Header says "December 2003". However in the ActiveX viewer over the web, the Group Header says "December 2,003.00", as does the tree view on the left-hand side.

I have tried converting to an integer in my @FormatDate formula, eg. int(year({@GroupDate})), but this does not help.

Does anyone have any suggestions?

 

[Reebo99]

to display as December 2003 etc use :

ToText(@GroupDate, "MMMM yyyy&quot


Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[ctwilliams]

That worked. Thanks!