Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DST - Report & DB are showing two different date/time values 1

Status
Not open for further replies.

mclubb

Programmer
Mar 12, 2007
2
US
I have some users that run reports from a crystal enterprise server that looks at a Remedy database. They are reporting that on some of the date/time fields are showing times 1 hour ahead of whats in Remedy. For instance:

Remedy shows a planned start date of
3/12/2007 12:01:00 AM

Report shows a planned start date of
3/11/2007 11:01:00 PM

This is also the same for the planned end date as well. Does anyone know what could be causing this? Is there any DST settings in Crystal Enterprise? I will be researching this to see if it is affecting any of the other time fields and reports.

Any help would be great.

Thanks,
Mike
 
I think that this is an issue with the server itself. I am not 100% sure if it has been patched or not. I am running this report on my local machine and it returns the correct information. I also moved this to another production server that has just recently been added and it isn't showing this same problem.

Thanks,
Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top