Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Time values are being displayed wrong Post Reply Post New Topic
Author Message
mkubala
Newbie
Newbie


Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Quote mkubala Replybullet Topic: Time values are being displayed wrong
    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.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
mkubala
Newbie
Newbie


Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Quote mkubala Replybullet 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

"
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.
"
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.