Print Page | Close Window

Time values are being displayed wrong

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2705
Printed Date: 18 Apr 2025 at 10:49pm


Topic: Time values are being displayed wrong
Posted By: mkubala
Subject: Time values are being displayed wrong
Date Posted: 25 Mar 2008 at 1:25pm
I'm using Crystal Reports 10 with ClearQuest 7.0.1. When I create a report using a field of DATE_TIME type from ClearQuest, Crystal Reports adds 5 or 6 hours exactly to that value when it is displayed in the report. The date, minutes, and seconds are the same, but 5 or 6 hours was added to the time. In almost all of the cases I tested it was 5 hours, but in one case it was 6 so I can't do a blanket formula to subtract the time.

Does anyone know why this is happening and how I could resolve it?

Thanks.


Replies:
Posted By: BrianBischof
Date Posted: 25 Mar 2008 at 9:14pm
Sorry, but I've never heard of this problem before. I would contact ClearQuest support to make see if the datetime format is standard or custom.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: mkubala
Date Posted: 26 Mar 2008 at 1:33pm

For those who run into the same issue you can find the answer here:

http://www-1.ibm.com/support/docview.wss?uid=swg21152189 - http://www-1.ibm.com/support/docview.wss?uid=swg21152189

"
Cause
The values in a date/time field are converted to GMT when they are stored in a ClearQuest database. Storing the date/time in GMT allows the data to be used throughout the world, regardless of the location and time zone. When Rational ClearQuest displays the date/time field values in a ClearQuest form, the local time has been calculated automatically from the GMT values in the database. However, the reports are reading the date/time directly from the database without converting the GMT into local time, even though the reports are displayed in Rational ClearQuest.
"


Print Page | Close Window