Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

US time format not consistent with Windows XP

The en-US date time format for date/time fields in Crystal Reports 2008 is not consistent with the regional settings of Windows XP.

The regional settings indicate the format is:

1/2/2008 2:45:26 PM

The format used by Crystal Reports is:

1/2/2008 2:45:26PM

The difference is the space between the seconds and the AM/PM designator and three spaces between the date and time (which gets truncated in the forum post).

I made a test application and there are numerous cultures which use AM/PM designators which fail. Below is a list of some which fail (I removed the triple spaces between date and time for this test, so this only shows the AM/PM designator issue):

Problem with English (Australia)

Expected: 1/01/2008 12:00:00 AM, Actual: 1/01/2008 12:00:00AM

Problem with English (Belize)

Expected: 01/01/2008 12:00:00 AM, Actual: 01/01/2008 12:00:00AM

Problem with English (Canada)

Expected: 01/01/2008 12:00:00 AM, Actual: 01/01/2008 12:00:00AM

Problem with English (New Zealand)

Expected: 1/01/2008 12:00:00 a.m., Actual: 1/01/2008 12:00:00a.m.

Problem with English (United States)

Expected: 1/1/2008 12:00:00 AM, Actual: 1/1/2008 12:00:00AM

The test application works by exporting to HTML and then parsing the HTML, but I've confirmed (by running the report) that at least the US does, in fact, exhibit this problem in the ReportViewer control.

Edited by: Sidney Forcier on Oct 21, 2008 2:52 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question