Date Field Formats showing up in decimal format 1

[pb100]

Hi,
I am using CRXI Developer, SQL Server and delivering reports on Crystal Reports Server. I have charts that use Year in the legend. Year is a formula: Year({datefield}) which displays as a 4 digit year in Developer (i.e. 2004). On CR Server, they show up as 2004.00. Is there a setting I'm missing??

Please help! TIA!!
-pb100

 

[RobbieB]

Try changing your formula for year to this:

totext (year({DateField}),"#")

 

[pb100]

Thank you so much!!! Works like a charm! Was racking my brain over this one...

 

[RobbieB]

No problem, I'm glad I could help.