E-CR: Crystal Date Format Issue (Doc ID 619839.1)

Last updated on MARCH 02, 2012

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.2 and later   [Release: 8.2 and later ]
PeopleSoft Enterprise PT PeopleTools - Version: 8.2 and later    [Release: 8.2 and later]
Information in this document applies to any platform.
SPECIFIC TO: Crystal date/number formats
Checked for Relevance on 02-Mar-2012

Symptoms

Running Crystal Reports through the Process Scheduler, the date and number formats have the separator added on.  This only occurs the Win2000 environment.

Field is defined as Date Format = "MMMM, DD YYYY".  It is outputed as  = "MMMM/DD/YYYY".
Field is defined as Number Format = "99,999,999.99".  It is Outputed as "99 999 999.99".

Running the same Crystal Report in the Crystal Designer, (outside of PeopleSoft), produces the correct results.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms