Skip to Content
0
Former Member
Apr 16, 2010 at 06:55 PM

Date Format Change in Crystal Reports After Installing BusinessObjects XI

273 Views

I have recieved the following request from a developer - W24 is to be our new production server BO Enterprise R3, W15 is BO XI. Problem is noticed on new server and not on the old. We need to resolve this issue to move ahead with migration to the new server.

Lewis,

This is the way the field is supposed to look and it comes out fine In Crystal Reports and on the W15 BO Enterprise.

5/2010 in Crystal Reports and on the W15 BO Enterprise

However, on the new W24 BO Enterprise, the field comes out like this:

5.00/2,010.00

EXP_GRAD_DATE is a DateTime field.

Here is the formula in Crystal Reports:

month({Command.EXP_GRAD_DATE}) & '/' & year({Command.EXP_GRAD_DATE})

Thanks

Cameron

Any help would be greatley appreciated!!